WEEKDAY with Monday as day 1
The second argument decides where the week starts — and makes weekends easy to test.
Task:
Deliveries booked for a Saturday or Sunday cost extra. In B2:B7 show Weekend or Weekday for each delivery date, using WEEKDAY with weeks starting on Monday.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of WEEKDAY
0/3The same formula in the other shapes it takes at work.
- WEEKDAY Function
Determine the day of the week using the WEEKDAY function.
CoreIntermediate - WEEKDAY with Monday as day 1
The second argument decides where the week starts — and makes weekends easy to test.
Intermediate - WEEKDAY to find the next Monday
Subtract how far into the week you are, then jump a week ahead.
Advanced
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Delivery date | Day type |
| 2 | 3/1/2024 | |
| 3 | 3/2/2024 | |
| 4 | 3/3/2024 | |
| 5 | 3/4/2024 | |
| 6 | 3/8/2024 | |
| 7 | 3/9/2024 |
What this exercise teachesMay contain the answer
With the default numbering, Sunday is 1 and Saturday is 7, so the weekend is split across both ends and needs an OR. Return type 2 puts the weekend together at 6 and 7, which turns the test into a single comparison.