Dates and reporting
WEEKDAY function: use return_type 2 to flag Saturday and Sunday cleanly
Switch WEEKDAY from its Sunday-first default to Monday-first numbering (return_type = 2) so Saturday (6) and Sunday (7) share a single >= 6 weekend test.
Why default WEEKDAY(date) splits the weekend in two
Without a second argument, WEEKDAY numbers Sunday as 1 and Saturday as 7—forcing a two-part OR(WEEKDAY(A2)=1, WEEKDAY(A2)=7) check. Passing 2 as return_type numbers Monday = 1 through Friday = 5, Saturday = 6, and Sunday = 7.
| Calendar date | Serial | WEEKDAY(d, 1) | WEEKDAY(d, 2) |
|---|---|---|---|
| Monday 2026-03-02 | 46083 | 2 | 1 |
| Friday 2026-03-06 | 46087 | 6 | 5 |
| Saturday 2026-03-07 | 46088 | 7 | 6 |
| Sunday 2026-03-08 | 46089 | 1 | 7 |
One >= 6 comparison flags both weekend days
With return_type = 2, every Monday–Friday workday sits in 1..5 and both weekend days sit at 6 and 7: =IF(WEEKDAY(A4, 2)>=6, "Weekend", "Workday") returns "Weekend" for both Saturday and Sunday.
=IF(WEEKDAY(A4,2)>=6,"Weekend","Workday")Test Monday, Friday, Saturday, and Sunday
Check Friday (A3 = 46087): WEEKDAY(A3, 2) returns 5 ("Workday"). Step forward one day to Saturday (46088) or two days to Sunday (46089) and the same formula returns "Weekend".
=WEEKDAY(A2,2)Try the example
Use the original values or change them to test your understanding.