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, or in your Time Zone & Region settings in iCloud Settings.

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.

See alsoDATEVALUETIME
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.