Owner manual
Chapter 3 Date and Time Functions 49
Related Topics
For related functions and additional information, see:
“DAY” on page 47
“MONTHNAME” on page 54
“WEEKDAY” on page 59
“Listing of Date and Time Functions” on page 42
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
DAYS360
The DAYS360 function returns the number of days between two dates based on
twelve 30-day months and a 360-day year.
DAYS360(start-date, end-date, use-euro-method)
 start-date: The starting date. start-date is a date/time value.
 end-date: The ending date. end-date is a date/time value.
 use-euro-method: An optional value that species whether to use the NASD or
European method for dates falling on the 31st of a month.
NASD method (0, FALSE, or omitted): Use the NASD method for dates falling on
the 31st of a month.
EURO method (1 or TRUE): Use the European method for dates falling on the 31st
of a month.
Examples
=DAYS360(”12/20/2008”, “3/31/2009”) returns 101d.
=DAYS360(”2/27/2008”, “3/31/2009”,0) returns 394d.
=DAYS360(”2/27/2008”, “3/31/2009”,1) returns 393d, as the European calculation method is used.
Related Topics
For related functions and additional information, see:
“DATEDIF” on page 45
“NETWORKDAYS” on page 54