Difference between revisions of "Manuals/calci/DAYSONMONTHLYBASIS"
Jump to navigation
Jump to search
| Line 16: | Line 16: | ||
#DAYSONMONTHLYBASIS("1/12/1990","9/12/1992") = 960 | #DAYSONMONTHLYBASIS("1/12/1990","9/12/1992") = 960 | ||
#DAYSONMONTHLYBASIS("13/2/2003[DD/MM/YYYY]","16/12/2006[DD/MM/YYYY]") = 1383 | #DAYSONMONTHLYBASIS("13/2/2003[DD/MM/YYYY]","16/12/2006[DD/MM/YYYY]") = 1383 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=5K84bWIt3nc|280|center|Month}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 15:00, 15 February 2019
DAYSONMONTHLYBASIS (IssueDate,MaturityDate,Basis)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle IssueDate} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaturityDate} are any date values.
Description
- This function will return the number of days with in the given range of dates.
- In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle DAYSONMONTHLYBASIS (IssueDate,MaturityDate,Basis)} ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Issuedate} is the starting date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaturityDate} 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 the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
- We can use range values also.For Example: DAYSONMONTHLYBASIS("9/3/2010",#2/8/2014-2/15/2014)
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
- DAYSONMONTHLYBASIS("13/2/2003[DD/MM/YYYY]","16/12/2006[DD/MM/YYYY]") = 1383
Related Videos
See Also
References