Difference between revisions of "Manuals/calci/DAYS360"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
<div style="font-size:30px">'''DAYS360(sd,ed,lv)'''</div><br/> | <div style="font-size:30px">'''DAYS360(sd,ed,lv)'''</div><br/> | ||
− | * | + | *<math>sd</math> is the starting date |
− | + | *<math>ed</math> is the end date | |
+ | *<math>lv</math> is the logical value like true or false | ||
==Description== | ==Description== | ||
− | *This function gives the number of days between given dates based on | + | *This function gives the number of days between given dates based on 360 day year (30 days in 12 months). |
− | *Here SD and ED are the two dates to find the in between | + | *Here SD and ED are the two dates to find the in between days. |
*LV is the logical value like TRUE or FALSE. | *LV is the logical value like TRUE or FALSE. | ||
− | *When logical value is true , then the result is based on U.S.method. | + | *When logical value is true, then the result is based on U.S.method. |
*when logical value is false, then the result is based on the European method . | *when logical value is false, then the result is based on the European method . | ||
− | *when we not giving any logical values it will consider the U.S method. | + | *when we are not giving any logical values it will consider the U.S method. |
− | *This function will give result as NAN , when the end date is before the starting date. | + | *This function will give result as NAN, when the end date is before the starting date. |
Revision as of 06:40, 18 November 2013
DAYS360(sd,ed,lv)
- is the starting date
- is the end date
- is the logical value like true or false
Description
- This function gives the number of days between given dates based on 360 day year (30 days in 12 months).
- Here SD and ED are the two dates to find the in between days.
- LV is the logical value like TRUE or FALSE.
- When logical value is true, then the result is based on U.S.method.
- when logical value is false, then the result is based on the European method .
- when we are not giving any logical values it will consider the U.S method.
- This function will give result as NAN, when the end date is before the starting date.
Examples
- DAYS360("12/13/2013","1/13/2014",TRUE)=30
- DAYS360("2/20/2013","3/3/2013",FALSE)= 13
See Also