Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
WEEKDAY. WEEKDAY(date) returns the day of the week as a number, but the default counts Sunday as 1 and Saturday as 7. WEEKDAY(date, 2) counts Monday as 1 through Sunday as 7, so the weekend is simply every value above 5.
=WEEKDAY(D2,2) gives 4 for a refund dated Thursday 6 Nov 2025
The warehouse is closed at weekends, and the ops lead wants to know how many orders in this sample land on a Saturday or Sunday.
In C2:C10, return the day of the week of each order date in column B, counting Monday as 1 and Sunday as 7. In F2, count how many orders fall on a weekend.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Day of week | |||||
| 2 | 50001 | 2025-01-01 | Weekend orders | |||||
| 3 | 50013 | 2025-01-04 | ||||||
| 4 | 50053 | 2025-01-18 | ||||||
| 5 | 50073 | 2025-01-26 | ||||||
| 6 | 50094 | 2025-02-01 | ||||||
| 7 | 50138 | 2025-02-16 | ||||||
| 8 | 50186 | 2025-03-04 | ||||||
| 9 | 50279 | 2025-04-03 | ||||||
| 10 | 50372 | 2025-05-02 | ||||||
| 11 | ||||||||
| 12 | ||||||||
| 13 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe