Traditional Culture Encyclopedia - Lucky day 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.
- Related articles
- Ask for the information of the advance team of Japanese invasion of Korea-God bless Xia Tuan.
- Date of birth, April 2022, is the best date for the baby to be born.
- When is February 2022 suitable for cleaning the house?
- 202 1 September when is the most auspicious day to install the gate? September 202 1 Suitable for Anmen zodiac auspicious day list.
- When is Robber's Day?
- Is today a good day to move? lucky day
- 202 1 can I move to a new home on the seventh day of the second lunar month?
- Why don't some couples pay attention to formal weddings?
- Lantern Festival handwritten newspaper stick figure
- How to treat buying a car and picking up a car on the auspicious day of the first month of 2023?