Excel Study · Module 2: Entering & formatting data
Class 12Dates are numbers
Basics1:39 videoFree
Every date in Excel is secretly a number: its day number, counting 1 January 1900 as day 1. That is why =B3-B2 gives the days between two dates. Switch a date's format to General and you see its number; Undo brings the date back.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B2 has an order date and B3 has the delivery date. Write a formula for B5 that gives the number of days between them.
The answer that works
✓ checked in Excel=B3-B2
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.