Tuesday, June 14, 2022

Show dates as days of the week [MS]

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 the Answers community.

See Also

TEXT

No comments:

Post a Comment

Search This Blog

Type fields [MS]

Type fields Project Online Desktop Client Project Professional 2021 P...