Get Day name from Date

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.


Excel Formulas

Uncategorized