Excel中怎么用函数判断闰年和平年答:=IF(OR((MOD(TEXT(A1,"yyyy"),4)=0)*(MOD(TEXT(A1,"yyyy"),100)<>0),AND(MOD(TEXT(A1,"yyyy"),{100,400})=0))=FALSE,"不是闰年","是闰年")
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中有年份上述二个都行