Day 76 · Sunday, 18 October 2026

From the archive

Intermediate

Build an employee tenure badge from years and leftover months with DATEDIF

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.

Task:

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.

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.