WEEKDAY
Returns the number representing the day of the week.
=WEEKDAY(A2)
Default numbering:
|
Day |
Number |
|
Sunday |
1 |
|
Monday |
2 |
|
Tuesday |
3 |
|
Wednesday |
4 |
|
Thursday |
5 |
|
Friday |
6 |
|
Saturday |
7 |
You can use:
=WEEKDAY(A2,2)
With return type 2:
Monday = 1
Sunday = 7
WEEKNUM
Returns the week number of a date.
=WEEKNUM(A2)
Practice
Create:
|
Date |
Day Number |
Week Number |
|
01-Sep-2026 |
||
|
10-Sep-2026 |
||
|
20-Sep-2026 |