Manuals/calci/DAYSONMONTHLYBASIS

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 range values also.For Example: DAYSONMONTHLYBASIS("9/3/2010",#2/8/2014-2/15/2014)

Examples

  1. DAYSONMONTHLYBASIS("9/3/2010","8/2/2014") = 1409
  2. DAYSONMONTHLYBASIS("2/2/1980","2/2/2000") = 7200
  3. DAYSONMONTHLYBASIS("1/12/1990","9/12/1992") = 960

See Also

References

DATE