Day 99 · Tuesday, 10 November 2026
A weekly cash forecast lists money in and money out, but the number a business owner needs is what is left in the bank each week, and when it is lowest. A running SUM with one end of its range locked carries every earlier week into the balance, and MIN with INDEX and MATCH then finds the worst week and names it.
You do the books for a landscaping company heading into its quiet winter months. The forecast in A2:C9 lists each week's expected receipts and payments, and the bank balance going in is in G1. In D2, write a formula for the closing balance at the end of that week, and copy it down to D9. Then in G2, find the lowest closing balance in the forecast, and in G3, return the week it happens, so you know how large an overdraft to arrange and when it has to be in place.
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.