Use Of Day360
StartDate
|
EndDate
|
Days Between
|
* See the Note below.
|
01-Jan-98
|
05-Jan-98
|
4
|
=DAYS360(C4,D4,TRUE)
|
01-Jan-98
|
01-Feb-98
|
30
|
=DAYS360(C5,D5,TRUE)
|
01-Jan-98
|
31-Mar-98
|
89
|
=DAYS360(C6,D6,TRUE)
|
01-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
मेरी कहानियाँ Index प्रतिदिन सुविचार
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें