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

Summary

This article describes how to return a day of the week for a date that is contained in a cell in Microsoft Excel.

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

  • In Microsoft Office Excel 2007, follow these steps:
    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. Click the Home tab.
    4. Click Format Cells: Number in the Number group. This will open the Format Cells dialog box.
    5. On the Number tab, click
      Date, and then select the date format that contains the day of the week in the Typelist.
    6. Click OK to close the Format Cells dialog box.
  • In Microsoft Office Excel 2003 and earlier versions of Excel, follow these steps:
    1. In the cell that you want to return the day of the week, type =A1, and then press ENTER.
    2. Select the cell that has 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 in the Typelist.
    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:
=text(a1,"ddd")


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:
=text(a1,"dddd")

Method 3

In the cell that you want to return the day of the week, type the following, and then press Enter:
=weekday(a1,1)
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.

References

For more information about how to use dates and times in Excel , click the following article number to view the article in the Microsoft Knowledge Base:

214094 HOW TO: Use Dates and Times in Excel

Propriedades

ID do Artigo: 827327 - Última Revisão: 29/04/2008 - Revisão: 1

Comentários