Display the Current Day of the Week in Excel

Add to Favorites
Author:

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.


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

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

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...
Pass Values from One Macro to Another Macro
Tutorial: How to pass variables and values to macros. This allows you to get a result from one macr...
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...