Power Query
published
Search
⌃K

Date.WeekOfYear

Date.WeekOfYear

Returns a number from 1 to 54 indicating which week of the year 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 54 indicating which week of the year the date, dateTime, falls in.

Category

Date

Examples

Determine which week of the year March 23rd, 2011 falls in (#date(2011, 03, 23)).
Date.WeekOfYear(#date(2011, 03, 23))
13