Microsoft Excel Functions & Formulas

Use the DAYS360 function to calculate with

a 360-day year

If there is an accounting system installed that is based on 12 30-day

months, the DAYS360 function can be used. This function returns

the number of days between two dates based on a 360-day year.

Here is the syntax:

DAYS360(start_date, end_date, method)

start_date: The start date.

end_date: The end date.

method: A logical value that specifies which method to use (U.S.

or European).

U.S. (NASD) method: Used if method is FALSE. If the starting

date is the 31st of a month, it is considered to be the 30th of the

same month. If the ending date is the 31st of a month and the

starting date is earlier than ...