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.
- Previous article:Lunar calendar April 26, 2020
- Next article:How to borrow money is better?
- Related articles
- What month is Scorpio?
- May is a good day to pick up the car.
- Lao Huangli received his certificate on auspicious day of the ecliptic. Enquiry telephone number 202 1
- Dreaming about the omen of pricing strategy
- What is the autumnal equinox on August 28th, 2022? Can you propose?
- Lao Huang Li got engaged on an auspicious day. Male: 1989-02- 19 is a snake, female: 1988-05-0 1 is a dragon. 20 10 what date is May suitable for engagement?
- Dream of the lottery before the game.
- When is the best time to burn incense in the morning and at night?
- Is March 14, 2023 an auspicious day to visit patients? February 23rd, 2023 is an auspicious day to visit patients.
- 20 19.03.05 lunar calendar