Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
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
Runs server-side · free · no signup
Step by step
- 1Enter your date in A2.
- 2To get the full day name (Monday, Tuesday, etc.), enter =TEXT(A2,"dddd").
- 3For the abbreviated name (Mon, Tue), use =TEXT(A2,"ddd").
- 4For a numeric day where 1=Sunday, 2=Monday ... 7=Saturday, use =WEEKDAY(A2).
- 5To change the start day, supply the second argument: =WEEKDAY(A2,2) makes Monday=1.
Tips
- Use WEEKDAY in IF or CHOOSE to create human-readable day labels with custom logic: =CHOOSE(WEEKDAY(A2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat").
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Why does TEXT(A2,"dddd") show the locale-specific day name?
TEXT uses the spreadsheet's locale settings, so the day name appears in the language of your system. This is usually desired but can differ between English and non-English locales.
How can I check if a date is a Monday?
Use WEEKDAY with return_type 2: =WEEKDAY(A2,2)=1 returns TRUE if the date is a Monday (where Monday=1 in this mode).