Dateeasy
DATE()
Constructs a date value from year, month, and day numbers.
Syntax
fx
=DATE(year, month, day)
Arguments
Example
fx
=DATE(2026, 5, 7)
Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and DATE isn't one of them yet.
Common pitfalls
DATE(2026, 13, 1)doesn't error: it rolls over to January 2027. Same for day overflow. Useful for math; surprising if you assumed validation.- Years 0-1899 are interpreted as offsets from 1900 by default. Pass full 4-digit years to avoid surprises.
Related formulas
Used by
TODAY()
Returns the current date as a date value.
NOW()
Returns the current date and time as a date value.
EOMONTH()
Returns the last day of the month a specified number of months before or after a date.
EDATE()
Returns the date a specified number of months before or after another date.
WEEKDAY()
Returns the day of the week for a date, as a number (default Sunday=1, Saturday=7).
NETWORKDAYS()
Returns the count of working days (Mon-Fri) between two dates, excluding optional holidays.
YEAR()
Returns the year component of a date as a four-digit number.
MONTH()
Returns the month component of a date as a number from 1 to 12.
DAY()
Returns the day of the month component of a date as a number from 1 to 31.