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.

See alsoDATEVALUETIME
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Полезна?
Ограничение на знаците: 250
Ограничението за знаци е 250.
Благодарим ви за обратната връзка.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.