Downloads
Power Query MDateBeginner

Date.DayOfWeekName

Returns the name of the day of the week of a date, such as "Thursday".

Syntax
Date.DayOfWeekName(dateTime as any, optional culture as nullable text) as nullable text

Returns: 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

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

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.

Related functions

All Power Query M functions · View as Markdown · M basics