Difference between revisions of "Manuals/calci/DAYS360"
Jump to navigation
Jump to search
Line 19: | Line 19: | ||
*<math>method</math> is the logical value either true or false. | *<math>method</math> is the logical value either true or false. | ||
*For e.g.,DAYS360("10/30/2010","6/15/2016",TRUE) = 2025. | *For e.g.,DAYS360("10/30/2010","6/15/2016",TRUE) = 2025. | ||
− | {{#ev:youtube|6MxgyrU7VB8| | + | {{#ev:youtube|6MxgyrU7VB8|280|center|Days360}} |
==Examples== | ==Examples== |
Revision as of 06:00, 13 June 2014
DAYS360(startdate,enddate,method)
- is the date from which date counting have to start.
- is the ending date of the counting.
- is the logical value either true or false.
Description
- This function gives the number of days between given dates based on 360 days in a year. (30 days in 12 months).
- Here and are the two dates to find the in between days.
- 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.
ZOS Section
- The syntax is to calculate DAYS360 in ZOS is .
- is the date from which date counting have to start.
- is the ending date of the counting.
- is the logical value either true or false.
- For e.g.,DAYS360("10/30/2010","6/15/2016",TRUE) = 2025.
Examples
- DAYS360("12/13/2013","1/13/2014",TRUE)=30
- DAYS360("2/20/2013","3/3/2013",FALSE)= 13