From the archive
Day 35
Monday, 7 September 2026
Work out when equipment has to ship, counting backward from a start date
WORKDAY doesn't only project forward — a negative day count walks backward across business days just as well, which is exactly what a ship-by date needs.
Task:
You handle onboarding logistics for Alderbrook Consulting's IT department. Each new hire has a confirmed start date, and equipment needs enough lead time to arrive before they walk in — the shipping team wants a ship-by date that counts backward from the start date by the lead time in business days, skipping weekends. Work out each hire's ship-by date in column D.
The daily challenge is part of Pro
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
Recent days
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.
- 38Day 38 · Thursday, 10 September 2026Split shipping addresses into city and stateLatest
- Day 37 · Wednesday, 9 September 2026Read a CD rate off a table laid out by term, not by row
- Day 36 · Tuesday, 8 September 2026Average order value for one channel and one region — then a threshold on top
- Day 35 · Monday, 7 September 2026Work out when equipment has to ship, counting backward from a start date
- Day 34 · Sunday, 6 September 2026Depreciate two fleet assets with the declining-balance method
- Day 33 · Saturday, 5 September 2026Rank race finishers without touching the bib-number order
- Day 32 · Friday, 4 September 2026Standardize signup emails and pull out each username
- Day 31 · Thursday, 3 September 2026Work out shipping cost from a shipping method, without a lookup table
- Day 30 · Wednesday, 2 September 2026Bill each customer for the seats they're on
- Day 29 · Tuesday, 1 September 2026Turn three weighted criteria into one vendor score
- Day 28 · Monday, 31 August 2026Work out take-home pay without repeating the gross pay three times
- Day 27 · Sunday, 30 August 2026Work out how many cartons an order needs, and what's left in the last one
- Day 26 · Saturday, 29 August 2026Average response time for one priority, one team
- Day 25 · Friday, 28 August 2026Set contract review deadlines from a rush flag