M3是合同到期时间
已过期xx天的公式=IF(DATEDIF(M3,TODAY(),"D")>0,"已过期"&DATEDIF(M3,TODAY(),"D")&"天",)
到期和还有xx天到期的公式=IF(DATEDIF(TODAY(),M25,"D")=0,"已到期",IF(DATEDIF(TODAY(),M25,"D")<=30,"还差"&DATEDIF(TODAY(),M25,"D")&"天到期",""))
这两个公式单独使用没有问题,但是怎么将两个公式合在一起不会有问题
我写成这样就不行(不会计算已经过期xx天)=IF(DATEDIF(TODAY(),M4,"D")=0,"已到期",IF(DATEDIF(TODAY(),M4,"D")<=30,"还差"&DATEDIF(TODAY(),M4,"D")&"天到期",IF(DATEDIF(M4,TODAY(),"D")>0,"已过期"&DATEDIF(M4,TODAY(),"D")&"天","""")))
ããexcelä¸:å³å¨ååå°æ è¿æxx天å°æ è¿æxx天 çå ¬å¼ä¹¦åæ¹å¼æ¯å¨F2åå æ ¼è¾å ¥=TEXT(30-DATEDIF(E2-30,TODAY(),"yd"),"0天åååå°æ;;ä»å¤©ååå°æ")ç¶ååå¡«å å ¬å¼å³å¯ã
ããä¸è¬éå®ä»F2èµ·çFåï¼ä¾æ¬¡ç¹å»âæ ¼å¼/æ¡ä»¶æ ¼å¼/å ¬å¼âï¼å¨å ¬å¼ç¼è¾æ¡ä¸è¾å ¥ä»¥ä¸å ¬å¼=AND(DATEDIF(TODAY(),F2,"D")>0,DATEDIF(TODAY(),F2,"D")<30)ï¼æ¥çä¾æ¬¡ç¹å»âæ ¼å¼/å¾æ¡/红è²/ç¡®å®/ç¡®å®âã