Difference between revisions of "Manuals/calci/DAYSONMONTHLYBASIS"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''DAYSONMONTHLYBASIS (IssueDate,MaturityDate,Basis)'''</div><br/> *<math>IssueDate</math> and <math>MaturityDate</math> are any date values. ==De...") |
|||
| Line 8: | Line 8: | ||
*This function is used to calculate the number of days in a given month from a issue date to the given month of a maturity date. | *This function is used to calculate the number of days in a given month from a issue date to the given month of a maturity date. | ||
*Also days are calculated under a monthly basis. | *Also days are calculated under a monthly basis. | ||
| + | *We can use range values also.For Example: DAYSONMONTHLYBASIS("9/3/2010",#2/8/2014-2/15/2014) | ||
==Examples== | ==Examples== | ||
Revision as of 14:07, 14 May 2018
DAYSONMONTHLYBASIS (IssueDate,MaturityDate,Basis)
- and are any date values.
and 
are any date values.Description
- This function will return the number of days with in the given range of dates.
- In , is the starting date.
- is the end date.
- This function is used to calculate the number of days in a given month from a issue date to the given month of a maturity date.
- Also days are calculated under a monthly basis.
- We can use range values also.For Example: DAYSONMONTHLYBASIS("9/3/2010",#2/8/2014-2/15/2014)
,
is the starting date.Examples
- DAYSONMONTHLYBASIS("9/3/2010","8/2/2014") = 1409
- DAYSONMONTHLYBASIS("2/2/1980","2/2/2000") = 7200
- DAYSONMONTHLYBASIS("1/12/1990","9/12/1992") = 960
See Also
References