From the archive
Day 30
Wednesday, 2 September 2026
Intermediate
Bill each customer for the seats they're on
VLOOKUP fetches a per-seat price, then it's just one multiplication to turn that into a bill.
Task:
You handle billing for a small SaaS company that resells seat-based licenses. Four customers are signed up on different plans, and the price per seat for each plan lives in a reference table to the right. Work out each customer's monthly bill in column D, then total the month's billing in D6.
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