IF函数,要以2个日期作条件答:b6 =if(and(b2>date(2012,1,1),b2<=today()-date(today())),j6,"")如果是大于1月(从2月1日开始),改为:=if(and(b2>date(2012,2,0),b2<=today()-date(today())),j6,"")
...减去b1格日期的结果,为负数时显示“生后办证”,为正数且小于...答:=IF((A5-B5)<0,"生后办证",IF((A5-B5)=0,"生时办证","生前办证"))那个小于4000还要吗 要的话 =IF((A5-B5)<0,"生后办证",IF((A5-B5)=0,"生时办证",IF(AND((A5-B5)>0,(A5-B5)<4000),"生前办证")))望采纳