Excel offers a plethora of valuable functions. In this article, we will discuss how to display 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.
New to Excel? Watch our Free Excel for Beginners Playlist on YouTube to get started with step-by-step video tutorials.
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 remaining 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
Post a Comment