How to get the day of the week in Excel 2010

To get the day of the week as a number you use Excel WEEKDAY function.

Syntax

WEEKDAY(serial_number,[return_type])

Serial number: a serial number that represent the date.

Return type (optional): a number that determines how the weekday is calculated. In other words, it specifies what is the first day of the week and whether numbering will start from 0 or will start from 1.

Here is a list of the valid return types:

1 or omitted       Numbers 1 (Sunday) through 7 (Saturday). Behaves like previous versions of Excel.

2             Numbers 1 (Monday) through 7 (Sunday).

3             Numbers 0 (Monday) through 6 (Sunday).

11           Numbers 1 (Monday) through 7 (Sunday).

12           Numbers 1 (Tuesday) through 7 (Monday).

13           Numbers 1 (Wednesday) through 7 (Tuesday).

14           Numbers 1 (Thursday) through 7 (Wednesday).

15           Numbers 1 (Friday) through 7 (Thursday).

16           Numbers 1 (Saturday) through 7 (Friday).

17           Numbers 1 (Sunday) through 7 (Saturday).

 

Examples:

 

Cell A1 have the date: 25/11/2012, which is Sunday.

 

  1. Cell B1 have the formula: =WEEKDAY(A1;1).  The value in B1 will be 1.
  2. Cell B1 have the formula: =WEEKDAY(A1;2).  The value in B1 will be 7.
  3. Cell B1 have the formula: =WEEKDAY(A1;16).  The value in B1 will be 2.
  4. Cell B1 have the formula: =WEEKDAY(A1;17).  The value in B1 will be 1.

 

Trackbacks

  1. [...] How-to-get-the-day-of-the-week-in-excel-2010 [...]