excel公式,时间差距几天答:假设2个日期在A1,B1 =LOOKUP(ABS(A1-B1),{0,3,7,10,15},{"3天之内","3-7天","7-10天","10-15天","15天以上"})
求助 难度等级 极高! excel 统计进货日期表里面,库存不是为0的 生产日...答:在M3中输入或复制粘贴下列公式 =IF(AND(K3>0,DATEDIF(J3,TODAY(),"M")>9),"还有"&DATEDIF(TODAY(),EDATE(J3,18),"M")&"月到保质期","")或 =IF(AND(K3>0,DATEDIF(J3,TODAY(),"M")>9),IF(TODAY()>EDATE(J3,18),"","还有"&DATEDIF(TODAY(),EDATE(J3,18),"M")&"月到...