excel的题目,使用函数判断是否为闰年,这个函数怎么写,求高手赐教答案...答:B1=IF(OR(AND(MOD(A1,100)=0,MOD(A1,400)<>0),MOD(A1,4)<>0),"平年","闰年")
Excel中给定年份,利用函数DATE,YEAR,MONTH,DAY判断是否闰年答:=if(date(year(A1)+1,3,1)-date(year(A1),2,1)=29,"闰年","不是闰年")=if(TEXT(DATE(year(a1),2,29),"d")="29","闰年","不是闰年")A1中有年份上述二个都行