How to get the day of the week from a date in Excel and Google Sheets

Excel & Google Sheets

=TEXT(A2, "dddd")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

Step by step

1Put the date in A2.
2Enter =TEXT(A2, "dddd") to show the full weekday name (e.g. Monday).
3Use "ddd" for the short name (Mon), or WEEKDAY(A2, 2) for a number with Monday = 1.

Tips

WEEKDAY(A2, 2) makes Monday=1 through Sunday=7 — handy for flagging weekends.
Flag weekends with =IF(WEEKDAY(A2, 2) > 5, "Weekend", "Weekday").

Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.

Frequently asked

How do I get just the weekday number?

Use WEEKDAY. The second argument sets the scheme — WEEKDAY(A2, 2) returns Monday=1 through Sunday=7.

Formulas used

WEEKDAY TEXT IF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026