Traditional Culture Encyclopedia - Almanac inquiry - How to add the year around the month uniformly in EXCEL?

How to add the year around the month uniformly in EXCEL?

In EXCEL, the specific steps to add the year before the month and day are as follows:

The materials we need to prepare are: computers, Excel forms.

1. First, we open the Excel table that needs to be edited.

2. Then we click on cell D 1, enter: = date (2009, month (C 1), day (C 1)), and press enter to confirm.

3. Then we click the cell D 1 and put the mouse cursor in the lower right corner of the cell. When the black cross icon appears, press and hold the left key to drop down and fill it.