未來天干年計算 (14202)

C2=MID("辛壬癸甲乙丙丁戊己庚",MOD(RIGHT(B3)-1,10)+1,1)&"年"

E2=B2+FIND(D2,MID(REPT("辛壬癸甲乙丙丁戊己庚",2),MOD(RIGHT(B2)-1,10)+2,99))

另解E2=MOD(FIND(D2,"辛壬癸甲乙丙丁戊己庚")-RIGHT(B2)-1,10)+1