您好,肖大哥就為大家解答關于excel計算倒計時天數，excel倒計時天數公式相信很多小伙伴還不知道,現在讓我們一起來看看吧！

1、在C2中輸入或復制粘貼此公式=IF(AND(A2<>"",B2="是"),"",A2+25-TODAY())或=IF(AND(A2<>"",B2="否"),A2+25-TODAY(),"")或=IF(AND(A2<>"",B2="是"),"",IF(A2+25-TODAY()>=0,A2+25-TODAY(),"已經過期"))或=IF(AND(A2<>"",B2="否"),IF(A2+25-TODAY()>=0,A2+25-TODAY(),"已經過期"),"")下拉填充。

本文就講到這里，希望大家會喜歡。