DAYSPERMONTH (days per month)

<< 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:

DAYSPERYEAR, YEAR, DAYS/DAYSP, DAYS360