Daily Excel puzzle

One formula to write, every day, in a live spreadsheet. The same puzzle for everyone, a new one at midnight. It takes about two minutes, and it's free.

How it works

What the puzzles are about

When a puzzle comes round again it has new names and numbers, so it is the skill you remember, not the answer. After each puzzle you see a formula that solves it, why it works, and the lesson that teaches it.

Common questions

When does the puzzle change?

At midnight where you are. Everyone gets the same puzzle on the same date.

Do I need Excel?

No. The puzzle runs in a spreadsheet in your browser that understands Excel formulas. What you practise works the same way in Excel and in Google Sheets.

What if I can't solve it?

Open a hint, then the second one. If it still won't come, ask for the answer. The day isn't counted as solved, but you see the formula, why it works and the lesson that teaches it.

Is my formula wrong if it differs from the answer shown?

No. Any formula that gets the right result from the data counts. Typing the result in doesn't.

How is the streak counted?

A day counts when you solve that day's puzzle. Miss a day and the streak starts again. It is kept in your browser, or with your account if you sign in.

Want more than one a day? Take the Excel skills test, or start the course.