How to return a day of the week for a date in Excel (827327)

MORE INFORMATION

To return a day of the week for a date, use one of the following methods.

Note Assume that cell A1 of your worksheet contains the date that you want to reference.

Method 1

1. In the cell that you want to return the day of the week, type =A1, and then press ENTER.
2. Select the cell with the returned date.
3. On the Format menu, click Cells.
4. On the Number tab, click Date, and then select the date format that contains the day of the week (second item in the list) in the Type list.
5. Click OK to close the Format Cells dialog box.

Method 2

If you want to return the day of the week as an abbreviation (for example, as Wed), type the following in the cell that you want to return the day of the week, and then press ENTER:

If you want to return the day of the week as a whole word (for example, as Wednesday), type the following in the cell that you want to return the day of the week, and then press ENTER:

Method 3

In the cell that you want to return the day of the week, type the following, and then press Enter:Note The second variable indicates the day of the week that the week begins. For example, the variable "1" indicates that the week starts on Sunday, while the variable "2" indicates that the week starts on Monday.

Dates that are earlier than March 1, 1900, may have inaccurate results.