Work with dates
Show the day of the week
=TEXT(A2,"dddd")How it works in Excel
- A2 is the date.
- "dddd" means the full day name.
- Use "ddd" for the short form, such as Mon.
- WEEKDAY gives the day as a number instead.
The idea in general
It looks the date up on a calendar and reads the column heading.
What I assumed
- The date is in A2.
Check the result on your own data before relying on it.