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,"")
EXCEL中IF函数多条件日期如何设置答:=IF(AND(I3>=DATE(2010,1,1),I3<=DATE(2010,6,30)),"120",IF(I3>=DATE(2010,7,1),"无",IF(I3<DATE(2010,1,1),"240")))