Exercises / Dates and deadlines · 8 of 10
Weekend or weekday?
WEEKDAY(date, 2) numbers the days Monday = 1 to Sunday = 7, so Saturday and Sunday are greater than 5. Without the 2, the week starts on Sunday = 1.
Your taskIn C2, use WEEKDAY and IF to return "Weekend" when the date in A2 is a Saturday or Sunday, and "Weekday" otherwise. It will be copied down to C8.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C |
|---|---|---|---|
| 1 | Date | Sales | Day type |
| 2 | 2 Mar 2026 | $1,840.00 | |
| 3 | 6 Mar 2026 | $2,210.00 | |
| 4 | 7 Mar 2026 | $3,105.00 | |
| 5 | 8 Mar 2026 | $2,870.00 | |
| 6 | 10 Mar 2026 | $1,695.00 | |
| 7 | 13 Mar 2026 | $2,390.00 | |
| 8 | 14 Mar 2026 | $3,320.00 |