How to display the day from a date in all letters in Excel ?

When using dates with Excel, it is more convenient to display the day name rather than the date in Excel’s Date format. How to display the name of the day from a date in all letters with Excel? Indeed, when you use Excel to manage schedules, readability is important. The date format of the day/month/year type in numeric, like for example “30/11/2017” is not necessarily the easiest to read.

How to display the name of the day in all letters from a date with Excel?

These two concrete examples allow you to display the day written in letters.

First option to display the day in four letters

To display the day in letters in Excel, one solution is to use the Excel function TEXT() with the day parameter on four letters: “dd dd”.

Display today’s name in full letter

=TEXT(TODAY(),"dddd")

Display day’s name from another cell in full letter

For example if the date to display in A1 cell:

=TEXT(A1,"dddd")

The result is Saturday for 01/01/2022 in A1.

So this formula will display the name of the day in all letters. That is to say the complete day. In this example the column will have the following format: Thursday

Note: The screenshots are from an English (UK) version of Excel, the syntax may vary depending on local language settings.

Second option to display the day in three letters only

In other words, to display only the first three letters of the day, you have to use the TEXT() function with the keyword “dd”.

=TEXT(TODAY(),"ddd") 
or 
=TEXT(A1,"ddd")

The result is Sat for Saturday

In addition, the list of days of the week with the formula that uses the three letter keyword will display the abbreviated days as below:

Mon
Tue
Wed
Thu
Fri
Sat
Sun

To conclude, this article presents how to display the days in a more explicit way with the list of days in letters. Note that this formula also allows you to manage the format for different information.

Among others: hours, weeks, months and years but also percentages, currencies with the symbol euro (€) or dollar ($) for example.

To go further, here is an article on how to select an entire column in Excel using a shortcut.

Be the first to comment

Leave a Reply