DAYS360 Function (Functions in Excel)
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. |
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 |
0 comments:
Post a Comment