Traditional Culture Encyclopedia - The 24 Solar Terms - Here are two EXCEL tables, how to use the known solar terms and years. Find the corresponding lunar date and time respectively? (4 functions in total)
Here are two EXCEL tables, how to use the known solar terms and years. Find the corresponding lunar date and time respectively? (4 functions in total)
=HLOOKUP($H3,$B$2:$F$ 1000,MATCH(INDIRECT(ADDRESS( 1,COLUMN()- 1+MOD(COLUMN(),2))),$A:$A,)-MOD(COLUMN(),2),)
Pull down to the right
- Previous article:What are the taboos for visiting seriously ill elderly people?
- Next article:Who are the moral figures of the Chinese nation?
- Related articles
- When does the cold weather start and end?
- When does rape blossom?
- What does a slight cold eat, and the principle is to reduce sweetness and increase bitterness?
- How do people in China spend Halloween?
- Wuling glory throttle back stuck.
- Citroen c5 accelerator pedal sensor failure.
- Proverbs and songs in the cold season
- Relationship between solar terms and gossip
- What is the story of the young woman in the first frost and the young woman in the first frost?
- I grow with plants. How to write the badge design introduction?