Date & Timebeginner
Count days remaining until a deadline with TODAY
=A2-TODAY()
Excel how-to guide
How to weekday name in Excel
Add a weekday column to a schedule, highlight weekend rows, or show which day of the week transactions occurred.
Step-by-step instructions
How to weekday name — 3 steps
1
Reference the cell containing the date.
2
Use "DDDD" as the format string to return the full weekday name.
3
Use "DDD" for the abbreviated name (Mon, Tue, Wed…).
Example data
Worked example
| Date | Day Name |
|---|---|
| 2026-03-23 | Monday |
| 2026-03-24 | Tuesday |
| 2026-03-28 | Saturday |
Common mistakes
Errors to watch out for
Returns "Wednesday" for every row
Make sure you are referencing a date cell, not a text string that looks like a date. Convert text dates with DATEVALUE first.
Language is wrong
TEXT returns day names in the language of your Excel installation. This cannot be changed without a custom formula using CHOOSE and WEEKDAY.
FAQ
Frequently asked questions
How do I check whether a date falls on a weekend?
Use WEEKDAY(A2,2) which returns 6 for Saturday and 7 for Sunday with Monday=1 numbering. Then use IF(WEEKDAY(A2,2)>5,"Weekend","Weekday").
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides
Continue learning.
Date & Timebeginner
Extract month and year from a date with MONTH and YEAR
=YEAR(A2)&"-"&TEXT(MONTH(A2),"00")