Power Query
published
Search
⌃K

Date.DaysInMonth

Date.DaysInMonth

Returns a number from 28 to 31 indicating the number of days in the month.
function (optional dateTime as nullable any) as nullable any

Description

Returns the number of days in the month in the date, datetime, or datetimezone value dateTime.

Category

Date

Examples

Number of days in the month December as represented by #date(2011, 12, 01)>.
Date.DaysInMonth(#date(2011, 12, 01))
31