TODAY
Returns the serial number of today's date.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
What it does
Returns the current date (updates when the workbook recalculates).
Syntax
TODAY()
Examples
Days until a date
Calculate days until the target date in A2.
FORMULA
=A2-TODAY()
RESULT
(varies)
SAMPLE DATA
| A | |
|---|---|
| 1 | Target date |
| 2 | 2026-02-01 |