Day 51 · Wednesday, 23 September 2026

From the archive

Intermediate

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.

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.