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!!!答:=DATE(MID(B3,7,4),MID(B3,11,2),MID(B3,13,2))年龄 =DATEDIF(D3,TODAY(),"Y")是否闰年 =IF(AND(OR(MOD(YEAR(D3),4)=0,MOD(YEAR(D3),400)=0),MOD(YEAR(D3),100)<>0),"是","否")VBA法 右键单击工作表标签 查看代码 粘贴如下公式,回到工作表,按CTRL+F8,运行这个代码...
excel计算两个日期之间有几年几个月答:=DATEDIF(SUBSTITUTE(B2,".","-"),SUBSTITUTE(C2,".","-"),"Y")&"年"&DATEDIF(SUBSTITUTE(B2,".","-"),SUBSTITUTE(C2,".","-"),"YM")&"个月"