Days360 Formula
|
|
StartDate
|
EndDate
|
Days Between
|
* See
the Note below.
|
|
|
1-Jan-98
|
5-Jan-98
|
4
|
=DAYS360(C4,D4,TRUE)
|
|
|
1-Jan-98
|
1-Feb-98
|
30
|
=DAYS360(C5,D5,TRUE)
|
|
|
1-Jan-98
|
31-Mar-98
|
89
|
=DAYS360(C6,D6,TRUE)
|
|
|
1-Jan-98
|
31-Dec-98
|
359
|
=DAYS360(C7,D7,TRUE)
|
|
|
|
|
|
|
|
What Does It Do?
|
|
|
|
|
|
Shows the
number of days between two dates based on a 360-day year (twelve 30-day
months).
|
||||
|
Use this
function if your accounting system is based on twelve 30-day months.
|
||||
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
=DAYS360(StartDate,EndDate,TRUE of FALSE)
|
|
|||
|
TRUE : Use this for European accounting
systems.
|
|
|||
|
FALSE : Use this for
|
|
|||
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
The
result will be shown as a number.
|
|
|
||
|
|
|
|
|
|
|
Note
|
|
|
|
|
|
The
calculation does not include the last day. The result of using 1-Jan-98 and
5-Jan-98 will
|
||||
|
give a result
of 4. To correct this add 1 to the result. =DAYS360(Start,End,TRUE)+1
|
||||