Date.DayOfWeekName
Returns the name of the day of the week of a date, such as "Thursday".
Date.DayOfWeekName(dateTime as any, optional culture as nullable text) as nullable textReturns: The day name as text, or null when the input is null.
What it does
Date.DayOfWeekName gives the weekday as a name, such as "Thursday". It is for display, such as a column in a daily cash report that the reader scans by name. For any logic, such as a weekend test, use the number from Date.DayOfWeek, because the name depends on language and does not sort in calendar order.
Syntax and arguments
- dateTime: a date or a datetime value.
- culture (optional): the culture for the name, such as "en-US" or "de-DE".
Example
A daily cash report shows each day with its weekday name so the treasurer can see which days are weekend days with no bank activity.
let
Days = #table(type table [CashDate = date, Balance = number],
{{#date(2026, 10, 29), 52000}, {#date(2026, 10, 31), 52000}}),
Labeled = Table.AddColumn(Days, "Weekday", each Date.DayOfWeekName([CashDate], "en-US"), type text)
in
Labeled
October 29 is labeled "Thursday" and October 31 is labeled "Saturday". The balance is the same on both days because no bank activity posts on a weekend, which the reader can now see at a glance.
Example: a second, different use
Write the day name into an email subject line for the daily cash report, using the same culture as the rest of the report.
Things to watch
- The name depends on the culture. Pass the culture so the names are consistent.
- Names do not sort in calendar order. Sort by the date.
- Use Date.DayOfWeek for weekend logic, not a comparison with the name text.
- Null in gives null out.
In business terms
Daily cash, sales and staffing reports are read by people who think in weekday names. Showing the name next to the date makes weekend patterns and holiday gaps visible without a calendar on the desk.