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")))
Excel表格使用if函数算日期的问题答:选择L列为零的单元格,条件格式--公式--输入 =OR(AND($A$1>=39814,$A$1<=39816),AND(A1>=39838,A1<=39844),AND(A1>=39907,A1<=39909),AND(A1>=39934,A1<=39936),AND(A1>=39961,A1<=39963),AND(A1>=40087,A1<=40094)),到格式里面输入字体加粗,颜色红色,即可~到这些日子中,它...