Display the Current Day of the Week in Excel

Add to Favorites

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

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...
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...
Get the Current Date in Excel
Tutorial: How to get the current date using Excel.  This method updates the date every day so that i...
Print Preview Screen Display for The Current or Selected Worksheets in Excel
Macro: This free Excel macro allows you to display the print preview screen or window for the cur...
Print The Current Worksheet in Excel
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...