EXCEL里面IF函数,关于订单交期追踪的,今天减去交货日期,大于3给一个值(剩余3天以上),小于3给一个值(即将到期),等于0给一个值(已交货),类似=IF(H3-TODAY()<=3,"即将到期"
公式为:
=IF(A2-TODAY()<1,"已交货",IF(A2-TODAY()<4,"即将到期","剩余3天以上"))
=IF(A2-TODAY()<1,"已交货",IF(A2-TODAY()<4,"即将到期","还剩"&A2-TODAY()&"天"))
如图所示: