如何在excel区分平年还是闰年

Question

如题所述

Answer 1

按照闰年四年一润，百年不润，四百年又润的规则，如果A1是年份的话
=IF(MOD(A1,100)=0,IF(MOD(A1,400)=0,"闰年","平年"),IF(MOD(A1,4)=0,"闰年","平年"))
如果A1是日期，外面套一层year（A1)

Answer 2

假设日期列是A列。在B1输入
=IF(MOD(YEAR(A1),4),"平年","闰年")
回车并向下填充。追问

条件是年份可以被4整除且不能被100整除，或者被400整除

追答

=IF(OR(MOD(YEAR(A1),400)=0,AND(MOD(YEAR(A1),100)>0,MOD(YEAR(A1),4)=0)),"闰年","平年")

Answer 3

用2月份最后一天的数字来判断就行了。
例如
=IF(DAY("2014-3-1"-1)=28,"平年","闰年")