Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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 or get support in Communities.

See Also

TEXT

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×