ExcelHeroThe WEEKDAY function
Returns the day of the week as a number.
In German Excel: WOCHENTAG
How to write it
=WEEKDAY(serial_number, [return_type])- serial_number
- A date.
- return_type
- 2 makes Monday 1 and Sunday 7.
💡 WEEKDAY(date,2)>5 means weekend.
Try it
On which weekday was order 1001 placed? Monday should be 1.
A
B
C
D
E
1
Order
Customer
Ordered
Delivered
Weekday
2
1001
Kim
3/3/25
3/7/25
3
1002
Ali
3/10/25
3/11/25
4
1003
Kim
4/2/25
4/9/25
5
1004
Jo
4/15/25
4/18/25
6
1005
Ali
5/20/25
5/23/25
WEEKDAY(date, 2) counts Monday as 1.