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.

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

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