Formula Errors

Keep Excel Formula Cells Blank When a Date Is Missing

Maira MehtabMaira Mehtab Nov 20, 2026 869 views

Question details

Keep a countdown formula and its status cell blank when the source date is missing.

Keep Excel Formula Cells Blank When a 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.
Before you start

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.

Solution 1Recommended

Add an IF check to the countdown and status formulas

Use this approach to display results only after a date is entered in A2.

1
Update the countdown

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.

2
Update the status

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.

3
Apply the formulas to other rows

Select B2:C2 and drag the fill handle down to copy the formulas. Each row will check its corresponding date cell.

4
Check recalculation settings

If results do not update, open Formulas > Calculation Options and select Automatic. You can also press F9 to recalculate.

Add an IF check to the countdown and status formulas
How the blank result works: The formulas return an empty string, so the cells look blank but still contain formulas. TODAY updates when the workbook recalculates.
WPS Spreadsheet

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. 1. Open your workbook: Open WPS Spreadsheet and choose Open to select your Excel workbook.
  2. 2. Enter the countdown formula: Select B2 and enter =IF(A2="","",MAX(0,A2-TODAY())).
  3. 3. Enter the status formula: Select C2 and enter =IF(A2="","",IF($B2>=1,"Upcoming",IF($B2=0,"Completed"))).
  4. 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.
Keep countdown and status cells visually blank when the date is missingOpen and edit Microsoft Excel XLSX and XLS filesCopy formulas down a column for multiple datesUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.