Traditional Culture Encyclopedia - The 24 Solar Terms - Simplification of calculating 24 solar terms function by Excel. The file extension of encoded image stored in jpeg file exchange format.
Simplification of calculating 24 solar terms function by Excel. The file extension of encoded image stored in jpeg file exchange format.
D4:
= mid(index(I $ 4:I $ 1 1,match (B4,datevalue(" 20 14 " &; MID($I$4:$I$ 1 1,6,FIND(" -",$ I $ 4:I $ 1 1)-6), 1),3,2)
Array formula, Ctrl+shift+Enter ends.
- Previous article:Eight kinds of mind maps used abroad
- Next article:Translation and appreciation of the original text of Moonlight Remembering Brothers
- Related articles
- What elements are used in the Spring Festival poster? What are the design concepts of Spring Festival posters?
- Slogans and propaganda words of tea box packaging
- How to describe a red skirt is more advanced?
- Perpetual calendar 199 1 calendar, 199 1 calendar lunar calendar.
- How to write a circle of friends during the Chinese New Year?
- "Five elements of water are short of gold; The sun is dry because of lack of water; There must be a wooden gang, but avoid being too hot. " What should I pay attention to?
- Cultural Park Tourism Map Cultural Park Landscape Map
- Excuse me, what year is June in history, and how is it calculated?
- I went to the hospital for lung CT, and the doctor said that it would be better to treat it early. It seems serious. There are thyroid nodules now. Chronic pharyngitis. Chronic gastritis, gastroptosis
- ? What should I say to express today's slight cold solar terms?