How to display the day of the week in Excel

Excel offers a plethora of valuable functions. In this article, we will discuss how to dispaly the day of the week in Excel when given a date. For instance, if the date is 8/01/2023, the output should be Tuesday.

The Text function is utilized to display the day of the week in Excel.

The Text function in Excel

The Text function is employed to alter the formatting of a number by applying format codes.

Syntax:

=TEXT(Value, format_Text)

As dates in Excel are stored as numbers, the Text function can be applied to dates to format them and display the corresponding day of the week.

Steps to display the day of the week in Excel

To illustrate this, I will utilize a sample dataset (provided below). It contains dates in the month of August. Additionally, there is an empty column designated for the Day of the Week, wherein we will apply our formula.

In the cell B2, I will write a formula:

=TEXT(A2,”dddd”)

In Cell A2, you will find the Date value. Utilizing the “dddd” format will provide us with the day of the week. I will then use the autofill feature to populate the remaning cells in column B, generating values for all the dates. The resulting output will be displayed as follows:

To obtain the abbreviated day of the week, utilize “ddd” instead.


Explore more insights like these and deepen your Excel proficiency with comprehensive knowledge from the book Excel Basics to Advanced.

Enhance your Excel skills by exploring MSExcel Blogs for more valuable tips.


About the Author

Chandraish Sinha has  20+ years of experience in Information Technology. He is an accomplished author and has published 11 books covering Business Intelligence related topics such as, Tableau, Power BI and Qlik. Checkout his Amazon Author profile.

His latest book Excel Basics to Advanced covers all the aspects of MS Excel and provides exercises for self-learning.

Similarly, his recent book, Dashboarding with Tableau, covers all the features in Tableau and includes exercises for self-learning.

He has implemented IT solutions in different domains viz. Pharmaceutical, Healthcare, Telecom, Financial and Retail.

He blogs regularly on various IT topics. Check them out in the links given below: 

Blogs

Learn Tableau

Learn All Bi

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.