The DATE function returns a date assembled from 3 numbers.
This function allows you to format dates in a convenient format and use them in further calculations and analysis.
Syntax
DATE(year, month, day)
Argument |
Description |
Permitted values |
|---|---|---|
year |
Year in date |
Numerical value (for example, 2025) or a reference to a cell containing a number |
month |
Month in date |
Numerical value (1‑12) or a reference to a cell containing a number |
day |
Day in date |
Numerical value (1‑31) or a reference to a cell containing a number |
Examples of use
Creating a date from three numbers
=DATE(2024, 3, 15)
Result: 03/15/2024.
Automatic date correction when entering a non-existent date
=DATE(2024, 2, 31)
Since February 2024 has 29 days, the result will be 03/02/2024 (automatically moves to the next month).
Notes
–The result of calculating the DATE function is a number. To display the result in date format, apply the “Date” number format to the cell.
–The DATE function automatically adjusts the numerical values of days and months if they exceed the acceptable ranges. For example, when entering =DATE(2023, 13, 32): the month “13” will be converted to “1” (January) of the following year (2024), and the day “32” will be converted to “1” (the first day) of the following month. The result will be 02/01/2024.