DATE
Returns the serial number of a particular date.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
What it does
Creates a date value from year, month, and day.
Syntax
DATE(year, month, day)
Arguments
year(number) — Year component.
Examples
Build a date
Create a date from year, month, day in A2:C2.
FORMULA
=DATE(A2,B2,C2)
RESULT
2026-03-15
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Year | Month | Day |
| 2 | 2026 | 3 | 15 |