Weekdays
There is a function for week days in Microsoft Excel.
WEEKDAY function WEEKDAY(serial_number,[return_type])
Serial_number Required. A sequential number that represents the date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2022,5,23) for the 23rd day of May, 2022. Problems can occur if dates are entered as text.
Or you can refer to the cell, which contains the date value.
Return_type Optional. A number that determines the type of return value.
| Return_type | Result |
| 1 or none | Numbers 1 (Sunday) through 7 (Saturday). |
| 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:
A cell that contains:
Sunday: =WEEKDAY(B2,2)>6
A cell that contains specific Days of the Week:
Only a Tuesday or a Thursday:=OR(WEEKDAY(B2,2)=2, WEEKDAY(B2,2)=4)
A cell (A2) containing the following Date value: 2/14/2008
| Formula | Description | Result |
| =WEEKDAY(A2) | Day of the week, with numbers 1 (Sunday) through 7 (Saturday) (5) | 5 |
| =WEEKDAY(A2, 2) | Day of the week, with numbers 1 (Monday) through 7 (Sunday) (4) | 4 |
| =WEEKDAY(A2, 3) | Day of the week, with numbers 0 (Monday) through 6 (Sunday) (3) | 3 |
Week Number
There is a function for week number in Microsoft Excel.
WEEKNUM functionWEEKNUM(serial_number,[return_type])
Serial_number Required. A date within the week. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
Return_type Optional. A number that determines on which day the week begins. The default is 1.
