Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!

Get Day Name from a Date in Excel

Add to Favorites

How to get the name of a day from a date in Excel. This returns, for example, "Tuesday" for the date October 4, 2016. I'll also show you how to use custom names for the days.


Return Full Day Name

Return Abbreviated Day Name

Return Custom Day Name


Return Full Day Name





Return Abbreviated Day Name





Return Custom Day Name

With this method, you can specify the names that you want to use for each day of the week.

=CHOOSE(WEEKDAY(A1),"Sunday Funday", "Sad Monday", "Boring Tuesday", "Hump-Day", "Thursday Drink Special", "Friday Finally", "Saturday YEAH")




Here, we use the WEEKDAY function to return a number from 1 to 7; that's all that function does and, by default, 1 is Sunday and 7 is Saturday. To change which day of the week starts with 1, read our tutorial on the WEEKDAY function.

Once we know what the number is for the day of the week, we put that inside the CHOOSE function for the first argument.

The following arguments in the CHOOSE function are the values that you want to output for the days of the week. Put them in order starting with the value that you want to be output when the WEEKDAY function returns 1.

You can output any value using this method; just make sure to put double quotation marks around it if it's text.


This is a nifty little trick to get the days of the week from dates and it's really easy to use.

Make sure to download the sample file attached to this tutorial to work with these examples in Excel.

Question? Ask it in our Excel Forum

Excel Function: CHOOSE(), TEXT(), WEEKDAY()
Downloadable Files: Excel File

Similar Content on TeachExcel
Return the ISO Week Number from a Date in Excel - UDF
Macro: Return the ISO Week Number in Excel with this UDF. This is a simple to use UDF (user defin...
Get the Name of a Worksheet in Macros VBA in Excel
Tutorial: How to get the name of a worksheet in Excel using VBA and Macros and also how to store tha...
Get a Date that is So Many Working Days Before or After a Date in Excel - WORKDAY
Tutorial: How to find a date that is so many days before or after a specified date, excluding weeken...
Get Comment Text from Cell Comments in Excel - UDF
Macro: This free Excel UDF outputs all text from a comment in Excel. This benefit of this UDF is ...
Change the Name of a Chart in Excel
Tutorial: How to change the name of a chart in Excel. This allows you to use a more intuitive char...
Output the File Path to and Name of a Workbook in Excel - UDF
Macro: Free Excel UDF (user defined function) that displays the full file path and name of an Exc...