① EXCEL 如何设置自动预警 要求发货日期超过10天没有回款的就显示预警，发货日期和回款日期不超过10天相差
给你两种方法你自己看做弄吧,附表参考
函数公式
=IF(A1="","",IF($A1<TODAY(),"没有回款",IF($A1=TODAY(),"今天到期",IF(A1-TODAY()<=10,A1-TODAY()&"天后到期",""))))
条件格式
=AND($A1-TODAY()>0,$A1-TODAY()<=10)