Formula Errors

Excel Formula to Add 10 Days to a Date and Leave Empty Cells Blank

Maira Mehtab Nov 13, 2026 868 views

Question details

Create a formula that adds 10 days to a report date and returns a blank when the source is empty or contains an error.

Add 10 Days to an Excel Date and Return a Blank for Empty Cells

Product: Microsoft Excel
Device & OS: not provided
Scenario: A report needs a calculated date 10 days after the report date.
Observed behavior: An empty or erroneous source should not produce an unintended date or visible formula error.

Before you start

Identify the cell or table column containing the report date and confirm that valid entries are stored as Excel dates. Choose an empty cell or column for the calculated result.

Solution 1Recommended

Use a Cell Reference to Add 10 Days and Hide Errors

Use this formula when the report date is in a regular worksheet cell.

Enter the formula

Select the result cell and enter =IFERROR(IF(A2<>"",A2+10,""),""). Replace A2 with the cell containing the report date.

Format the result

Select the result cell, press Ctrl+1, and choose Date on the Number tab. Select a date format and click OK.

Apply it to other rows

Drag the result cell's fill handle down to copy the formula alongside the remaining report dates.

Use a Cell Reference to Add 10 Days and Hide Errors

Errors are hidden: IFERROR returns a blank for any formula error, including an error in the source cell. Check the source if an expected result is blank.

Solution 2

Use a Structured Reference in an Excel Table

Use this version when the report date is in an Excel table column named Report Date.

Calculate dates in WPS

Add Days to Report Dates in WPS Spreadsheets

Use the same IF and IFERROR formula in WPS Spreadsheets to calculate a date 10 days later while leaving empty or erroneous source cells blank.

1. Open the workbook: Open WPS Spreadsheets and use Open to select your workbook.
2. Enter the formula: Click the result cell and enter =IFERROR(IF(A2<>"",A2+10,""),""). Replace A2 with the report date cell.
3. Set the date format: Select the result cell, open Format Cells, and choose a Date format.
4. Copy the formula: Drag the cell's fill handle down to apply the formula to the other rows.

Add days to report dates without displaying a result for empty cellsOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and date formattingWork with a free, easy-to-use office suite

microsoft office alternative - wps office

Frequently Asked Questions

Why does an empty date cell produce a date when I add 10?

Excel can treat an empty cell as zero in arithmetic. Use =IFERROR(IF(A2<>"",A2+10,""),"") to check for an empty source before adding days.

How can I add a different number of days?

Replace 10 in the formula with the number of days you need. For example, use =IFERROR(IF(A2<>"",A2+30,""),"") to add 30 days.

Why does the result show a number instead of a date?

Excel stores dates as serial numbers. Select the result cell, press Ctrl+1, and choose Date on the Number tab.

How do I remove a green error indicator?

Select the flagged cell, click the warning icon, and choose Ignore Error if appropriate. To disable indicators globally, go to Excel Options > Formulas > Error Checking and clear Enable background error checking. This does not correct the underlying formula or data.

Excel & Data Problems