excel判断闰年

Question

=IF(A2/4<>0,"平年",IF(A2/100<>0,"闰年",IF(A2/400<>0,"平年","闰年")))
这样算哪里错了啊？

Answer 1

改成=IF(MOD(A2,4)<>0,"平年",IF(MOD(A2,100)<>0,"闰年",IF(MOD(A2,400)<>0,"平年","闰年")))
取余数要用mod函数。

Answer 2

假设出身日期在A2单元格(必须确定A2单元格输入的是正确的日期格式)
在B2单元格输入公式
=if(or(mod(year(a2),400)=0,and(mod(year(a2),4)=0,mod(year(a2),100)<>0)),"是","否")

Answer 3

=IF(OR(AND(MOD(A2,4)=0,MOD(A2,100)<>0),MOD(A2,400)=0),"闰年","平年")
=IF(MONTH(DATE(A2,2,29))=2,"闰年","平年")
http://zhidao.baidu.com/question/203381207.html
推荐下

参考资料：http://zhidao.baidu.com/question/203381207.html