Table of Contents
Formula using TEXT function
TEXT function in Excel can be used to get the Day Name (Sunday, Monday, etc.,) from a valid Excel Date.
When the date ‘26/08/2019‘ is used inside TEXT function with “DDDD” as it’s second argument the formula will return ‘Monday’, the weekday corresponding to that date.
=TEXT("26-08-2019","DDDD")
“DDDD” will return the day name in full and for the short form, use “DDD”.
Formula using CHOOSE and WEEKDAY functions
Another formula to find Day name is using CHOOSE and WEEKDAY functions.
The following formula will return ‘Thu‘, the weekday corresponding to the date “20/10/2011“.
=CHOOSE(WEEKDAY("20-10-2011"),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
WEEKDAY function will return the number corresponding to the weekday (1-7) from a Date. When the date “20/10/2011” is used inside it, WEEKDAY function will return the value, 5.
=WEEKDAY("20-10-2011")
This number is then used inside CHOOSE function to return the corresponding Day Name.
=CHOOSE(5,"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
Display Day Name corresponding to dates
For an Excel cell to display the corresponding weekday of a Date, apply the following Number Formatting (DDDD) to that cell.
Dates in the selected cells are displayed as corresponding weekdays.
