<< Click to Display Table of Contents >> DAYSPERMONTH (days per month) |
Syntax:
DAYSPERMONTH(Date)
Description:
Returns the number of days in the specified month.
Compatibility notes:
This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.
Example:
DAYSPERMONTH("09/25/2018") returns 30 (days)
DAYSPERMONTH("10/25/2018") returns 31 (days)
If cell A1 contains the date value 09/25/2018: DAYSPERMONTH(A1) returns 30 (days)
See also: