.

DAYS360 Function Dictionary

Function Dictionary Function Examples Function Categories

DAYS360      
 
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

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download