Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date.AddDays
Date.AddMonths
Date.AddQuarters
Date.AddWeeks
Date.AddYears
Date.Day
Date.DayOfWeek
Date.DayOfWeekName
Date.DayOfYear
Date.DaysInMonth
Date.EndOfDay
Date.EndOfMonth
Date.EndOfQuarter
Date.EndOfWeek
Date.EndOfYear
Date.From
Date.FromText
Date.IsInCurrentDay
Date.IsInCurrentMonth
Date.IsInCurrentQuarter
Date.IsInCurrentWeek
Date.IsInCurrentYear
Date.IsInNextDay
Date.IsInNextMonth
Date.IsInNextNDays
Date.IsInNextNMonths
Date.IsInNextNQuarters
Date.IsInNextNWeeks
Date.IsInNextNYears
Date.IsInNextQuarter
Date.IsInNextWeek
Date.IsInNextYear
Date.IsInPreviousDay
Date.IsInPreviousMonth
Date.IsInPreviousNDays
Date.IsInPreviousNMonths
Date.IsInPreviousNQuarters
Date.IsInPreviousNWeeks
Date.IsInPreviousNYears
Date.IsInPreviousQuarter
Date.IsInPreviousWeek
Date.IsInPreviousYear
Date.IsInYearToDate
Date.IsLeapYear
Date.Month
Date.MonthName
Date.QuarterOfYear
Date.StartOfDay
Date.StartOfMonth
Date.StartOfQuarter
Date.StartOfWeek
Date.StartOfYear
Date.ToRecord
Date.ToText
Date.WeekOfMonth
Date.WeekOfYear
Date.Year
Time.EndOfHour
Time.StartOfHour
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
Date.EndOfWeek

Date.EndOfWeek

Returns the last day of the week.
function (optional dateTime as nullable any, optional firstDayOfWeek as nullable any) as nullable any

Description

Returns the last day of the week in the provided date, datetime, or datetimezone dateTime. This function takes an optional Day, firstDayOfWeek, to set the first day of the week for this relative calculation. The default value is Day.Sunday.

Category

Date

Examples

Get the end of the week for 5/14/2011.
1
Date.EndOfWeek(#date(2011, 5, 14))
Copied!

date(2011, 5, 14)

Get the end of the week for 5/17/2011 05:00:00 PM -7:00, with Sunday as the first day of the week.
1
Date.EndOfWeek(#datetimezone(2011, 5, 17, 5, 0, 0, -7, 0), Day.Sunday)
Copied!

datetimezone(2011, 5, 21, 23, 59, 59.9999999, -7, 0)

Previous
Date.EndOfQuarter
Next
Date.EndOfYear
Last modified 3yr ago
Copy link
Contents
Date.EndOfWeek
Description
Category
Examples