Keep an Excel EDATE Formula Cell Blank Until a Date Is Entered
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.
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.
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.
Click the cell that contains your EDATE formula and select its contents in the formula bar.
Replace the formula with =IF(R3="","",EDATE(R3,12)), changing R3 and 12 if your source cell or month offset is different.
Press Enter. Leave R3 empty to confirm the formula cell appears blank, then enter a date in R3 to check the calculated result.
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. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 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. 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. Save the workbook: Select Save or Save As to save your changes in the desired workbook format.

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.




