China Naming Network - Ziwei Dou Shu - 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.