writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 8:
Line 8: + Line 14:
Line 15: +
Manuals/calci/DAYSONMONTHLYBASIS (view source)
Revision as of 20:11, 22 May 2018
, 20:11, 22 May 2018no edit summary
*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 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)
*We can use range values also.For Example: DAYSONMONTHLYBASIS("9/3/2010",#2/8/2014-2/15/2014)
#DAYSONMONTHLYBASIS("2/2/1980","2/2/2000") = 7200
#DAYSONMONTHLYBASIS("2/2/1980","2/2/2000") = 7200
#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
==See Also==
==See Also==