Day 96 · Saturday, 7 November 2026
Agencies bill by the week, but timesheets arrive one day at a time. Subtracting WEEKDAY from a date walks it back to the Monday that week started on, and the return type you pick decides whether a Sunday shift lands in the right week or the next one.
You handle billing at a staffing agency, and the client is invoiced each week, Monday to Sunday. The timesheet in A2:C9 has one line per shift. In D2, write a formula that returns the Monday of the week each shift falls in, and copy it down to D9. Then in G2, total the hours billed for the week commencing in F2, and copy that down to G3.
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.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.