Difference between revisions of "Manuals/calci/DAYS360"
Jump to navigation
Jump to search
| (5 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''DAYS360( | + | <div style="font-size:30px">'''DAYS360(startdate,enddate,method)'''</div><br/> |
| − | + | *<math>startdate</math> is the date from which date counting have to start. | |
| − | *<math> | + | *<math>enddate</math> is the ending date of the counting. |
| − | *<math> | + | *<math>method</math> is the logical value either true or false. |
| − | *<math> | ||
==Description== | ==Description== | ||
| − | *This function gives the number of days between given dates based on 360 | + | *This function gives the number of days between given dates based on 360 days in a year. (30 days in 12 months). |
| − | *Here <math> | + | *Here <math>startdate</math> and <math>enddate</math>are the two dates to find the in between days. |
| − | *<math> | + | *<math>method</math> 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 are 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. | ||
| + | |||
| + | ==ZOS== | ||
| + | *The syntax is to calculate DAYS360 in ZOS is <math>DAYS360(startdate,enddate,method)</math>. | ||
| + | *<math>startdate</math> is the date from which date counting have to start. | ||
| + | *<math>enddate</math> is the ending date of the counting. | ||
| + | *<math>method</math> is the logical value either true or false. | ||
| + | *For e.g.,DAYS360("10/30/2010","6/15/2016",TRUE) = 2025. | ||
| + | {{#ev:youtube|6MxgyrU7VB8|280|center|Days360}} | ||
==Examples== | ==Examples== | ||
| − | |||
*DAYS360("12/13/2013","1/13/2014",TRUE)=30 | *DAYS360("12/13/2013","1/13/2014",TRUE)=30 | ||
*DAYS360("2/20/2013","3/3/2013",FALSE)= 13 | *DAYS360("2/20/2013","3/3/2013",FALSE)= 13 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|4CfTkI37jaM|280|center|DAYS360}} | ||
==See Also== | ==See Also== | ||
*[[Manuals/calci/DATE | DATE]] | *[[Manuals/calci/DATE | DATE]] | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/DAY | DAY]] |
==References== | ==References== | ||
| + | *[http://en.wikipedia.org/wiki/360-day_calendar| 360 DAYS] | ||
Latest revision as of 11:56, 3 June 2015
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.
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
- 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