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