Show dates as days of the week

Let's say you want to see the date displayed for a date value in a cell as "Monday" instead of the actual date of "October 3, 2005." There are several ways to show dates as days of the week.

Note: The screenshot in this article was taken in Excel 2016. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same.

Format cells to show dates as the day of the week

  1. Select the cells that contain dates that you want to show as the days of the week.

  2. On the Home tab, click the dropdown in the Number Format list box, click More Number Formats, and then click the Number tab.

    Number Format list box
  3. Under Category, click Custom, and in the Type box, type dddd for the full name of the day of the week (Monday, Tuesday, and so on), or ddd for the abbreviated name of the day of the week (Mon, Tue, Wed, and so on).

Convert dates to the text for the day of the week

To do this task, use the TEXT function.

Example

Copy the following data to a blank worksheet.

1

2

3

A

Date

19-Feb-2007

3-Jan-2008

Formula

Description (Result)

=TEXT(A2, "dddd")

Calculates the day of the week for the date and returns the full name of the day of the week (Monday)

=TEXT(A3, "ddd")

Calculates the day of the week for the date and returns the abbreviated name of the day of the week (Thu)

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

TEXT

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×