Level 2Dates, Part 2Practice, 2 min
WEEKDAY: weekend or weekday?
The task
Support wants to know which tickets came in on a weekend. In C2, show Weekend if the date in B2 is a Saturday or Sunday, otherwise Weekday. Use
WEEKDAY with type 2, which numbers Monday as 1.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | |
|---|---|---|---|
| 1 | Ticket | Opened | Day type |
| 2 | T-4410 | Sun Mar 15, 2026 | |
| 3 | T-4411 | Mon Mar 16, 2026 |