Returns the serial number of a particular date.
구문
DATE(year, month, day)인수
year필수
The year component, typically a 1-4 digit number.
month필수
The month of the year, represented by a number from 1 to 12.
day필수
The day of the month, represented by a number from 1 to 31.
The DATE function creates a valid date value from individual year, month, and day components. It is particularly useful when date components are stored in separate cells or generated by other formulas.
=DATE(2023, 12, 25)→2023-12-25Returns the date for December 25, 2023.
Select the cell
Click on the cell where you want the date to appear.
Enter the formula
Type =DATE(year, month, day) and provide the numeric values for each argument.
The function adds that number of months to the first month of the specified year.