Day 35 · Monday, 7 September 2026

From the archive

Intermediate

Work out when equipment has to ship, counting backward from a start date

WORKDAY doesn't only project forward — a negative day count walks backward across business days just as well, which is exactly what a ship-by date needs.

Task:

You handle onboarding logistics for Alderbrook Consulting's IT department. Each new hire has a confirmed start date, and equipment needs enough lead time to arrive before they walk in — the shipping team wants a ship-by date that counts backward from the start date by the lead time in business days, skipping weekends. Work out each hire's ship-by date 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.

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.