DATE
The DATE function combines separate values for year, month, and day and returns a date/time value. Although dates can usually be entered directly as strings (for example, “12/31/2010”), using the DATE function ensures the date will be interpreted consistently, regardless of the date format specified in your Language & Region settings. All arguments are number values.
DATE(year, month, day)
year: The year to include in the value returned. The value isn’t converted. If you specify 10, the year 10 is used, not the year 1910 or 2010.
month: The month to include in the value returned. month should be in the range 1 to 12.
day: The day to include in the value returned. day should be in the range 1 to the number of days in month.
Notes
Language & Region settings are in System Preferences in macOS 12 and earlier, in System Settings in macOS 13 and later, in Settings in iOS and iPadOS.
Examples |
|---|
If A1 contains 2014, A2 contains 11, and A3 contains 10: =DATE(A1,A2,A3) returns Nov 10, 2014, which is displayed according to the cell’s current format. =DATE(A1,A3,A2) returns Oct 11, 2014. |