Power Query
published
Search
K
Comment on page

Date.WeekOfMonth

Date.WeekOfMonth

Returns a number from 1 to 5 indicating which week of the month this date falls in.
function (optional dateTime as nullable any, optional firstDayOfWeek as nullable any) as nullable any

Description

Returns a number from 1 to 5 indicating which week of the year month the date dateTime falls in.

Category

Date

Examples

Determine which week of March the 15th falls on in 2011 (#date(2011, 03, 15)).
Date.WeekOfMonth(#date(2011, 03, 15))
3