SheetsdrillOrders placed at the weekend
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Count the orders that came in on a Saturday or Sunday. Use WEEKDAY inside SUMPRODUCT so it runs on every date at once. Answer in E1.
What this exercise teaches
With type 2, the weekend is simply "greater than 5", one test instead of two. SUMPRODUCT evaluates its arguments as arrays, so WEEKDAY runs on every date without ARRAYFORMULA.
A hint if you get stuck
WEEKDAY(date, 2) numbers the days Monday 1 to Sunday 7, so a weekend is a value above 5. Multiply the TRUE/FALSE result by 1 and SUMPRODUCT adds it up.
Try it now, free, no account needed
The first 15 tasks on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exerciseMore exercises in Text and dates
- First name with SPLITPro
- Join the confirmed namesPro
- Address without gapsPro
- Valid order IDsPro
- Pull out the invoice numberPro
- Digits onlyPro
- Month label with TEXTPro
- Full years of servicePro
- Working days with holidaysPro
- Due at the end of next monthPro
- Tidy up pasted namesPro
- Items in a comma listPro
- Domain of an email addressPro
- Renewal date with EDATEPro
- Amount inside a sentencePro