Day 96 · Saturday, 7 November 2026

From the archive

Intermediate

Group Timesheet Lines by Week with WEEKDAY

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.

Task:

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.

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.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.