DATE
Date & TimeDATE helps you perform date and time helpers for scheduling, intervals, and calendar-aware calculations.
Overview
Start with "=" then enter DATE(year, month, day). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=DATE(year, month, day)
3 required
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| year | Required | Single | Year value. |
| month | Required | Single | Month value. |
| day | Required | Single | Day value. |
Example Inputs & Outputs
Formula
=DATE(2026,3,1)
Example Output
2026-03-01
Builds a valid date from year, month, and day parts.