| Line 1: |
Line 1: |
| − | <div style="font-size:30px">'''DAYS360(sd,ed,lv)'''</div><br/> | + | <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>sd</math> is the starting date | + | *<math>enddate</math> is the ending date of the counting. |
| − | *<math>ed</math> is the end date | + | *<math>method</math> is the logical value either true or false. |
| − | *<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 360 day year (30 days in 12 months). | + | *This function gives the number of days between given dates based on 360 days in a year. (30 days in 12 months). |
| − | *Here <math>sd</math> and <math>ed</math>are the two dates to find the in between days. | + | *Here <math>startdate</math> and <math>enddate</math>are the two dates to find the in between days. |
| − | *<math>lv</math> is the logical value like TRUE or FALSE. | + | *<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 Section== |
| | + | *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. |
| | | | |
| | ==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 |