This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use.
Learn more
Developer Network
Developer Network
Developer
Sign in
Subscriber portal
Get tools
Downloads
Visual Studio
SDKs
Trial software
Free downloads
Office resources
SharePoint Server 2013 resources
SQL Server 2014 Express resources
Windows Server 2012 resources
Programs
Subscriptions
Overview
Administrators
Students
Microsoft Imagine
Microsoft Student Partners
ISV
Startups
Events
Community
Magazine
Forums
Blogs
Channel 9
Documentation
APIs and reference
Dev centers
Samples
Retired content
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Power Query (M) Formula Reference
Power Query M function reference
Date functions
Date functions
Day.Saturday
Day.Saturday
Day.Saturday
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.StartOfWeek
Date.StartOfQuarter
Date.StartOfYear
Date.ToRecord
Date.ToText
Date.WeekOfMonth
Date.WeekOfYear
Date.Year
Day.Friday
Day.Monday
Day.Saturday
Day.Sunday
Day.Tuesday
Day.Wednesday
#date
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.
This documentation is archived and is not being maintained.
Day.Saturday
About
Returns 7, the number representing Saturday.
Show:
Inherited
Protected
Print
Export (
0
)
Print
Share
IN THIS ARTICLE