Excel concept

How dates and times work

A date is a serial day count from January 1, 1900; a time is a fraction of a day. Formatting only changes the display.

Daily driverDifficulty 1177 · Proficient

The shape of it

In practice: Do arithmetic on the serial numbers directly; use DATE, EDATE, and EOMONTH for calendar math.

Learn the moves here — or let Wauvel run them on your numbers.

$99/mo, everything included. Free for 14 days, no card.

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.