Question

Excel中我想显示日期与日期之间相差的月数,分成3段显示,3个月以内，4-6个月，7个月以上.

=IF(1<DATEDIF(AA5,AB5,"m")<=3,"<3M",IF(4<=DATEDIF(AA5,AB5,"m")<=6,"4~6M",IF(7<=DATEDIF(AA5,AB5,"m"),">7M")))

我用这个公式为什么只能显示7个月以上的，另两个区间的都显示“False”呢？

Answer 1

公式中不用用1<DATEDIF(AA5,AB5,"m")<=3这样类似在方式，可以用AND()函数，具体修改如下，希望能帮到你

=IF(AND(DATEDIF(AA5,AB5,"m")<=3,DATEDIF(AA5,AB5,"m")>=1),"<3M",IF(AND(DATEDIF(AA5,AB5,"m")<=6,DATEDIF(AA5,AB5,"m")>=4),"4~6M",IF(DATEDIF(AA5,AB5,"m")>=7,">7M")))

Answer 2

=IF(DATEDIF(AA5,AB5,"m")<=3,"<3M",IF(DATEDIF(AA5,AB5,"m")<=6,"4~6M",,">7M"))
这样修改一下……
你原来的 公式中 条件 段 使用格式错误……

Answer 3

=IF(DATEDIF(AA5,AB5,"m")<=3,"<=3M",IF(DATEDIF(AA5,AB5,"m")<=6,"4~6M",">=7M"))