Formula Errors

Keep an Excel EDATE Formula Cell Blank Until a Date Is Entered

Olivia MillerOlivia Miller Nov 14, 2026 868 views

Question details

Keep an EDATE formula cell visually blank until its source cell contains a date.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet uses EDATE to calculate a date 12 months after the date entered in a source cell.
Observed behavior
When the source cell is empty, the formula displays a date such as 12/31/1900 instead of remaining blank.
Before you start

Identify the source cell and the cell containing your EDATE formula. The example below uses R3 as the source and adds 12 months; adjust both values to match your worksheet.

Solution 1Recommended

Wrap the Excel EDATE formula in an IF statement

Use an IF check to display a blank result until the source cell has a date.

1
Select the formula cell

Click the cell that contains your EDATE formula and select its contents in the formula bar.

2
Add the empty-cell check

Replace the formula with =IF(R3="","",EDATE(R3,12)), changing R3 and 12 if your source cell or month offset is different.

3
Test the result

Press Enter. Leave R3 empty to confirm the formula cell appears blank, then enter a date in R3 to check the calculated result.

The formula cell is not truly empty: The formula returns an empty text value when R3 is blank. It does not remove the formula from the cell.
Use WPS Spreadsheets

Keep EDATE Results Blank in WPS Spreadsheets

Use the same IF and EDATE formula in WPS Spreadsheets to hide the result until a source date is entered.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Enter the formula: Select the result cell and enter =IF(R3="","",EDATE(R3,12)) in the formula bar. Adjust the cell reference and month offset as needed.
  3. 3. Check the calculation: Press Enter, then type a date in R3 to confirm the result appears. Clear R3 to check that the result looks blank again.
  4. 4. Save the workbook: Select Save or Save As to save your changes in the desired workbook format.
Keep date calculations visually blank until data is enteredOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and a straightforward interface
microsoft office alternative - wps office

Frequently Asked Questions

Why does EDATE show a date when the source cell is empty?

A blank source cell can be treated as a zero date value in the calculation, producing an unexpected date. Wrap EDATE in IF, such as =IF(R3="","",EDATE(R3,12)), to suppress the result.

Can I use a different number of months?

Yes. Replace 12 in =IF(R3="","",EDATE(R3,12)) with the number of months you need. Use a negative number to calculate an earlier date.

Is the formula cell really empty when it looks blank?

No. The cell still contains the formula, which returns an empty text value when the source cell is blank.

What if the result is not displayed as a date?

Select the result cell in Excel and choose a date format from Home > Number Format. Also check that the source cell contains a valid date rather than unrecognized text.