From the archive
Day 51
Wednesday, 23 September 2026
Align contract renewal dates to month-end, then count down the months left
EOMONTH rounds a date stepped forward by whole months onto the last day of wherever it lands, in the same move — and DATEDIF's "M" unit turns two dates into a whole number of months instead of a span of days nobody asked for.
Task:
You handle renewals for the IT department's software maintenance contracts. To keep invoicing simple, every contract is set to renew on the last day of a month rather than on the exact anniversary of its start date. For each contract below, use EOMONTH in column D to step the start date in column B forward by its term length in column C and land on that month's last day — the renewal date. Then, measuring from today's review date of September 23, 2026, use DATEDIF in column E to work out how many whole months remain until each renewal.
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.
- 52Day 52 · Thursday, 24 September 2026Decide who qualifies for tuition reimbursement from two rules that both have to clearLatest
- Day 51 · Wednesday, 23 September 2026Align contract renewal dates to month-end, then count down the months left
- Day 50 · Tuesday, 22 September 2026Split supplier PO references into order number and revision count
- Day 49 · Monday, 21 September 2026Schedule onboarding tasks a fixed number of working days from a start date
- Day 48 · Sunday, 20 September 2026Flag over- and under-budget departments in a quarterly variance report
- Day 47 · Saturday, 19 September 2026Bill only the memberships that are actually still active
- Day 46 · Friday, 18 September 2026Price a pick list against a supplier catalogue that no longer lists everything
- Day 45 · Thursday, 17 September 2026Find how much to deposit today to cover a multi-year scholarship payout
- Day 44 · Wednesday, 16 September 2026Report a fair "typical" salary when one outlier skews the average
- Day 43 · Tuesday, 15 September 2026Look up a placement fee from a category-by-level fee grid
- Day 42 · Monday, 14 September 2026Clean migrated customer names for a CRM import
- Day 41 · Sunday, 13 September 2026Sort machined shafts into Pass, Rework, or Scrap from two tolerance windows
- Day 40 · Saturday, 12 September 2026Weigh a GPA by credit hours instead of by course count
- Day 39 · Friday, 11 September 2026Report a call center's hold times without one outlier setting the headline number