DAYS 360

Posted on 22-01-2020 , by: admin , in , 0 Comments

days 360

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 USA accounting systems.

Formatting
The result will be shown as a number.

Leave a comment