Formula----Insert function----Enter function name DATE-----Click Go----Click OK.
#The DATE function consists of three parameters. The first parameter represents the year value or the cell range where the year value is located. The second parameter represents the month value or the cell where the month value is located, and the third parameter represents the date value or the cell range where the date value is located.
The specific formula for automatically generating dates in the A4 area using the DATE function is: =DATE(A2,C2,1)
Result:
Adjustment:
Select the cell to be formatted----right-click the mouse-----Select Set Cell Grid format---select number----select date----select March 14----click OK.
For more related tutorials, please pay attention to theexcel tutorialcolumn on the php Chinese website!
The above is the detailed content of Excel automatically generates dates. For more information, please follow other related articles on the PHP Chinese website!