Display the Current Day of the Week in Excel

Add to Favorites
Author: don

Use a formula or formatting to display the current day of the week in Excel.

Sections:

Formula to Show Current Day of Week

Formatting to Show Current Day of Week

Notes

Formula to Show Current Day of Week

This formula will update every day to show the current day of the week.

=TEXT(TODAY(),"dddd")

5a2f860d9a4b8987cd1e82a163ddd82c.png

Result:

c5f709da5db37ef5ac6e80a5200c415d.png

The TODAY() function returns the current day.

The TEXT() function allows us to return only the day of the week instead of any other part of the date.

You could also use NOW() instead of TODAY() if you need the current time for something else in the worksheet. The weekday would still be the only thing visible in the cell using the TEXT() function.

You can use dddd to show the full day name or ddd to show an abbreviated version of the day name.

Formatting to Show Current Day of Week

If you already get the current day of the week entered into the workbook via a macro or from imported data, you can use simple formatting to return the day-of-week value from the date.

  1. Right-click the cell with the date and click Format Cells...
    e1c6150c5423b3d482c3e31b747cefaa.png
  2. Go to the Number tab and click the Custom category and under where it says Type: input dddd to show the full day or ddd to show an abbreviated version of the day name.
    f4051c455e6630f3e09f579fc59511d8.jpg
  3. Hit OK and that's it!
    acef11e8f642690eef00d3594f3d48a6.png

Notes

To get the current day in a formula, we are just combining either NOW() or TODAY() with the TEXT() function in order to return a custom format for the date.

Make sure to download the sample Excel file to work with this example.

Question? Ask it in our Excel Forum


Excel Function: NOW(), TEXT(), TODAY()
Downloadable Files: Excel File

Similar Content on TeachExcel
Get the Last Day of the Month in Excel
Tutorial: How to get the last day of the month, including the date and day of week, for any date in ...
Print the Current Date or Time in Excel
Tutorial: How to print the current date and or time on an Excel spreadsheet. This is a simple techni...
Disable/Enable Buttons in UserForms
Tutorial: How to have a button in a UserForm disabled until the desired event occurs. For instance, ...
Save the Current Worksheet as a New File in the Current Folder
Macro: This Excel Macro saves the currently visible worksheet into the SAME folder as the current...
Capitalize the First Letter of Every Word in a Cell
Macro: This macro will make the text of any selected cell in excel proper case. This means that t...
Get the Current Date in Excel
Tutorial: How to get the current date using Excel.  This method updates the date every day so that ...
Tutorial Details
Excel Function: NOW(), TEXT(), TODAY()
Downloadable Files: Excel File
Similar Content
Get the Last Day of the Month in Excel
Tutorial: How to get the last day of the month, including the date and day of week, for any date in ...
Print the Current Date or Time in Excel
Tutorial: How to print the current date and or time on an Excel spreadsheet. This is a simple techni...
Disable/Enable Buttons in UserForms
Tutorial: How to have a button in a UserForm disabled until the desired event occurs. For instance, ...
Excel Forum