E1单元格写入公式
=IF(D1="","",FIND(D1,"子丑寅卯辰巳午未申酉戌亥"))
=IF(D1="","",MATCH(D1,{"子","丑","寅","卯","辰","巳","午","未","申","酉","戌","亥"},))
=IF(D1="","",VLOOKUP({"子",1;"丑",2;"寅",3;"卯",4;"辰",5;"巳",6;"午",7;"未",8;"申",9;"酉",10;"戌",11;"亥",12},2,))
下拉填充公式
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024