如题所述
假设A1中是要判断的日期,则在B1输入公式=IF(COUNT(--(A1&"-2-29")),"闰年","平年")
根据寥若_晨星2013的提醒,为了避免“误人子弟”,现在把公式改为:
=IF(OR(AND(MOD(A1,4)=0,MOD(A1,100)),MOD(A1,400)=0),"闰年","平年")
强烈推荐采纳寥若_晨星2013的答案!