Excel day of the week in letters

With the Excel software, it is more convenient to display the Excel day of the week rather than the date in a numeric Date format. Indeed, when using dates with Microsoft Office and especially Excel to manage statistics and schedules tables, readability is important. So, how to display Excel weekday in letters from a date with a simple formula?

The date format of the day/month/year type in numeric, like for example “30/11/2017” is not the easiest to read to analyse data.

Display the Excel day of the week in all letters from a date with a formula

These two concrete examples allow you to display the weekday written in all letters for the first case, or only the first three letters for the second option.

The first option is to display the day of the week in all letters

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

Display today’s name in full letter

Simply add a formula in a cell, use the Text() function.

Then add the TODAY() keyword as the first argument and the “dddd” as the second argument for the function.

=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.

The second option is to display the weekday in three letters

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

Of course, if your source value is in another cell, then use the cell reference, here it is A1 in the second formula.

=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 Excel weekday in a much 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

Your email address will not be published.


*