Return a Blank Cell with EDATE When a Source Date Is Empty in Excel
Question details
Return a visually blank result when the source date is empty, and otherwise calculate a date 60 months later.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet uses EDATE to add 60 months to a date in cell D2 and display the result in Q2.
- Observed behavior
- EDATE can display an unexpected date when the source cell is blank.
Check that D2 is the source date cell and Q2 is where you want the result. When D2 contains a date, make sure it is a valid spreadsheet date rather than unrecognized text.
Check the Source Cell Before Calculating EDATE
Use an IF formula to display a blank result when D2 is empty and add 60 months when it contains a valid date.
Open the worksheet and select cell Q2.
In Q2 or the formula bar, enter =IF(D2="","",EDATE(D2,60)) and press Enter.
Leave D2 empty to verify that Q2 appears blank, then enter a valid date in D2 to check that Q2 shows the date 60 months later. If needed, use Home > Number Format to format Q2 as a date.

Handle Blank EDATE Source Cells in WPS Spreadsheet
Use the same IF and EDATE formula in WPS Spreadsheet to keep the result visually blank until a source date is entered.
- 1. Open the spreadsheet: Launch WPS Spreadsheet and open your workbook.
- 2. Enter the formula: Select Q2, type =IF(D2="","",EDATE(D2,60)), and press Enter.
- 3. Test and format the result: Enter a valid date in D2 and check Q2. If the result appears as a number, select Q2 and choose a date format from the Home tab.

Frequently Asked Questions
Why does EDATE show a date when D2 is empty?
A blank source can be treated as a zero date value by the calculation. Use =IF(D2="","",EDATE(D2,60)) in Q2 to check D2 before running EDATE.
Is the result cell truly empty when the source date is blank?
No. The formula returns an empty string, so the cell looks blank but still contains a formula.
How do I apply the formula to other rows?
Enter the formula in Q2, then drag its fill handle down column Q. The relative reference to D2 will adjust for each row.
What if the result appears as a number instead of a date?
Select Q2 and choose a date format from Home > Number Format in Excel, or use the date formatting option on the Home tab in WPS Spreadsheet.




