Day 76 · Sunday, 18 October 2026
DATEDIF's "y" unit counts only the years that have fully turned over between two dates, and its "ym" unit answers a different question on the same two dates — how many months are left once those years are set aside — so the two together cover a tenure figure that neither one alone would get right.
You maintain HR records for a mid-size consulting firm, and performance review packets are due to show each employee's tenure as a readable badge rather than a raw hire date. As of today's review date, October 18, 2026, use DATEDIF in column C to find each employee's completed years of service, and DATEDIF again in column D for the whole months left over beyond that last anniversary. Then in column E, join the two into a label like "7 years, 9 months" with &. Fill in rows 2 through 6.
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.