Microsoft Office Tutorials and References
In Depth Information
year to Week 7, Day 6 of another year, you are assured that you are
comparing a Saturday to a Saturday and can have a like comparison.
• Some accounting systems use a 360-day calendar. In this type of
system, the year is divided into 12 months of 30 days. There is special
handling for months with 31 days. Unfortunately, U.S. and European
accounting boards disagree on the special handling, so there are two
sets of rules.
Out of these three alternative calendar systems, Excel handles only the
360-day calendar. Excel provides the DAYS360 function and the YEARFRAC
function to deal with the date system.
The DAYS360 function returns the number of days between two dates, based
on a 360-day year (twelve 30-day months), which is used in some accounting
calculations. You use this function to help compute payments if your ac-
counting system is based on twelve 30-day months. This function takes the
end_date — These are the two dates between which you
want to know the number of days. If start_dateoccurs after end_date,
DAYS360 returns a negative number. Dates may be entered as text
strings within quotation marks (for example, "1/30/2015", "2015/01/
30"), as serial numbers (for example, 42034, which represents Janu-
ary 30, 2015, if you ’ re using the 1900 date system), or as results of
other formulas or functions (for example, DATEVALUE("1/30/2015")).
method — This is a logical value that specifies whether to use the
U.S. or European method in the calculation:
• FALSE or omitted is a U.S. (National Association of Securities
Dealers) method. If the starting date is the 31st of a month, it be-
comes equal to the 30th of the same month. If the ending date is the
31st of a month and the starting date is earlier than the 30th of a
month, the ending date becomes equal to the 1st of the next month; oth-
erwise, the ending date becomes equal to the 30th of the same month.
• TRUE is a European method. Starting dates or ending dates that oc-
cur on the 31st of a month become equal to the 30th of the same month.