From the archive

Day 13

Sunday, 16 August 2026

Day 12Day 14
Beginner

Split an employee ID into department and hire year

The department and hire year are baked into the ID — once you know where to cut.

Task:

You work in HR analytics and need a headcount report broken down by department and hire year. Employee IDs follow a fixed pattern: three letters for the department, a dash, the four-digit hire year, a dash, then a sequence number. Split each ID: put the department in column C and the hire year in column D.

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.

See what Pro includesBack to the latest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.