Dates & Time

Excel formula for Get the day of the week

Return the weekday name (Monday…) or number for a date.

Copy this formula

=TEXT(A2, "dddd")

How the formula works

TEXT with "dddd" gives the full weekday name and "ddd" the short name. For a number, WEEKDAY returns 1–7 (Sunday = 1 by default), which is handy for flagging weekends.

Examples

=TEXT("2026-06-23", "dddd")→Tuesday

Returns the weekday name.

Other ways to do this

Flag weekends

=IF(WEEKDAY(A2, 2)>5, "Weekend", "Weekday")

Code 2 makes Mon=1…Sun=7.

FAQ

How do I get a number instead of a name?

Use =WEEKDAY(A2) for 1–7, with an optional second argument to choose the week start.

Related formulas

Get the week number from a date Count working days between dates

Functions used

TEXT WEEKDAY

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free