Day 30 · Wednesday, 2 September 2026

From the archive

Intermediate

Bill each customer for the seats they're on

VLOOKUP fetches a per-seat price, then it's just one multiplication to turn that into a bill.

Task:

You handle billing for a small SaaS company that resells seat-based licenses. Four customers are signed up on different plans, and the price per seat for each plan lives in a reference table to the right. Work out each customer's monthly bill in column D, then total the month's billing in D6.

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.