Microsoft Office Tutorials and References
In Depth Information
DAYS360
DAYS360
DAYS360 returns the number of days between two set dates based on a 360-day year.
=DAYS360(start_date,end_date)
The DAYS360 function is used primarily for accounting systems based on a 360-day year—if,
for example, you calculate payments based on twelve 30-day months. Notice the example. In
looking at Figure 4.3, you’ll notice the DAYS360 function in cell D7 calculates the number of
days between the start date of 3/16/2000 and 3/16/2005 to be 1800. This number divided by
30 gives you the number of payments. The second example builds the 30-day diviser into the
formula as shown in D12. And last, you’ll see that the DAYS360 function is used with text dates
in cell D18, and that the dates are enclosed by quotes and are separated with a comma.
The start and end dates for which you want the number
of days returned between. If the end date is less than
the start date, the result is a negative number.
START AND END DATE
A
Used with cell reference
Figure 4.3
The DAYS360
formula operates
on a 360-day year
accounting system—
twelve 30-day months.
B
Used with
30-day divisor
C
Used with text dates
EDATE
EDATE returns the value or serial number of the date specified by you and the number of
months before or after the specified date. Use EDATE to calculate the maturity date or date due
that falls on the same day of the month as the date of issue.
=EDATE(start_date,months)
The EDATE function is found in the Analysis Toolpak. If you don’t see the EDATE function, you
must first install the Analysis Toolpak and then enable the Toolpak under Add-Ins from the
Tools menu. In Figure 4.4, the start date in cell B8 = 3/16/1999 and the number of months to
Search JabSto ::




Custom Search