Traditional Culture Encyclopedia - The 24 Solar Terms - How to calculate year, month and day with EXCEL formula?
How to calculate year, month and day with EXCEL formula?
1. Enter 2008-9-9 in cell A 1, as shown.
2. Enter 20 14-8-8 in cell A2, as shown.
3. Click cell A3 and enter the formula "? DATEDIF(A 1, A2, "d") ",as shown in the figure.
4. Enter to get the result, 2 159, as shown in the figure.
- Previous article:What are the folk customs in Xi 'an? The history of cultural snacks
- Next article:Skills of fishing wild crucian carp in the first frost
- Related articles
- Japan travel list Japan tour group price inquiry
- Test Drive Tucki P7 Rear Drive Long Life Smart Edition: Life is hot because of "it"!
- Is the blind box made in China?
- What does it mean to enjoy flowers in groups in Xiao Chun?
- Three characteristics of beginning of winter.
- Write seven-character poems about the cold and solar terms.
- It gets cold in autumn. How do parents dress their babies? What are the precautions?
- The Origin and Story of New Year's Day
- My car stalled easily when it was downshifted. What is the reason?
- Winter Olympics solar terms display