| 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/> |
| | | | |
| − | *where 'sd' is the starting date,'ed' is the end date and 'lv' is the logical value like true or false | + | *<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 360day year (30 days in 12 months). | + | *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 these two dates. | + | *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. |
| | | | |
| | | | |