Keep Excel Formula Cells Blank When a Date Is Missing
Question details
Keep a countdown formula and its status cell blank when the source date is missing.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet calculates the days remaining from a date in A2 and displays a status based on the result.
- Observed behavior
- The countdown formula returns zero when A2 is blank, which can also cause the status cell to show Completed.
Identify the date cell, countdown cell, and status cell in your worksheet. The formulas below assume these are A2, B2, and C2, respectively, and that entered dates are recognized by Excel as dates.
Add an IF check to the countdown and status formulas
Use this approach to display results only after a date is entered in A2.
Select B2 and enter =IF(A2="","",MAX(0,A2-TODAY())). This returns an empty string when A2 is blank; otherwise, it shows the remaining days without going below zero.
Select C2 and enter =IF(A2="","",IF($B2>=1,"Upcoming",IF($B2=0,"Completed"))). The status stays blank without a date, shows Upcoming for a future date, and shows Completed for today or a past date.
Select B2:C2 and drag the fill handle down to copy the formulas. Each row will check its corresponding date cell.
If results do not update, open Formulas > Calculation Options and select Automatic. You can also press F9 to recalculate.

Keep Date Countdown Cells Blank in WPS Spreadsheet
Use the same IF, MAX, and TODAY formulas in WPS Spreadsheet to hide countdown and status results until a date is entered.
- 1. Open your workbook: Open WPS Spreadsheet and choose Open to select your Excel workbook.
- 2. Enter the countdown formula: Select B2 and enter =IF(A2="","",MAX(0,A2-TODAY())).
- 3. Enter the status formula: Select C2 and enter =IF(A2="","",IF($B2>=1,"Upcoming",IF($B2=0,"Completed"))).
- 4. Copy and test: Drag the fill handle from B2:C2 down to the other rows, then enter a valid date in column A to check the results.

Frequently Asked Questions
Why does my countdown show zero when the date is blank?
Excel treats a blank cell as zero in the calculation, and MAX(0,A2-TODAY()) prevents the result from going below zero. Wrap the calculation in IF(A2="","",...) to hide the result when A2 is blank.
Why does the status say Completed when there is no date?
The status formula may be reading a zero from the countdown cell. Check A2 first with =IF(A2="","",IF($B2>=1,"Upcoming",IF($B2=0,"Completed"))).
Will a date in the past show a negative countdown?
No. MAX(0,A2-TODAY()) returns zero for today or a past date, so the status formula shows Completed.
What can I do if the countdown does not update?
In Excel, select Formulas > Calculation Options > Automatic, or press F9 to recalculate. TODAY changes when the workbook recalculates.
Is a cell containing an empty-string formula truly empty?
No. The cell looks blank, but it still contains a formula that returns an empty string. This distinction can matter when other formulas check the cell.




