<!-- https://learnsql.cpetoday.com/functions/m/date-dayofweekname -->
# Date.DayOfWeekName

Language: Power Query M
Category: Date
Syntax: Date.DayOfWeekName(dateTime as any, optional culture as nullable text) as nullable text
Summary: Returns the name of the day of the week of a date, such as "Thursday".
Returns: The day name as text, or null when the input is null.
Level: Beginner
Related: Date.DayOfWeek, Date.MonthName, Date.ToText, Date.StartOfWeek, Date.Day

## 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.

```powerquery
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.
