Day 107 · Wednesday, 18 November 2026
A mileage log never lines up neatly with the pay period: trips from last month sit above it, trips from next week sit below it, and the odd one gets logged late, out of order. Two date conditions on the same column pick out exactly the period's trips, wherever they happen to sit, and change with the dates rather than with your selection.
You are a field sales rep, and finance pays mileage twice a month. Your trip log is in A2:C11, in the order you typed it up, which is not quite the order you drove it. The claim period is in F2 and F3, from 11/1/2026 to 11/15/2026, both days included. In F4, total the miles you drove in that period, reading the dates from F2 and F3 rather than typing them into the formula. Then in F6, turn the miles into the amount to claim at the rate in F5.
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.