Formula Errors

How to Add 14 Days to a Date in Excel Using a Formula

Maira Mehtab Sep 27, 2026 871 views

Question details

The user needs to calculate an upcoming schedule date by adding 14 days to a previous date, ensuring the formula leaves the cell blank if the source date row is empty.

Product: Excel Online
Device & OS: not provided
Scenario: Calculating future recurring schedules, such as agency nurse visits, based on past visit dates while handling unpopulated data rows cleanly.
Observed behavior: Adding days directly can cause empty cells to return unwanted dates. Furthermore, the calculated result often displays as a five-digit serial number instead of a standard readable date format.

Before you start

Verify that your original dates are formatted as Date rather than Text; otherwise, adding days to them will result in a #VALUE! error.

Solution 1Recommended

Use the IF Function to Add Days and Ignore Blanks

This method evaluates whether the source cell is empty before calculating the future date, preventing Excel from adding 14 days to a zero value.

In Excel, adding a number to a date adds that many days. However, if you apply this to an empty cell, Excel treats it as the start of its calendar (January 0, 1900) and calculates from there. By wrapping the addition in an IF statement, we can force Excel to output a blank cell if the source cell is also blank.

Enter the IF formula

Select the cell where you want the future visit date to appear (e.g., E2). Type the formula `=IF(D2="","",D2+14)` assuming the previous visit date is in D2.

Apply to multiple rows

Press Enter to confirm the formula. Click the cell again, grab the fill handle at the bottom-right corner, and drag it down to fill the formula across your desired rows.

Format the result as a date

Select the newly calculated cells. Right-click, choose 'Format Cells', select the 'Number' tab, click on 'Date', pick your preferred date format, and click OK.

Understanding Date Serial Numbers: Excel stores dates internally as sequential serial numbers. If your formula returns a 5-digit number like 44927, the calculation is correct, but the cell is formatted as 'General'. Changing the format to 'Date' will instantly resolve this.

Efficient Date Calculations

Calculate Dates Easily in WPS Spreadsheet

WPS Spreadsheet provides robust support for all standard date functions, including logical IF formulas, making it simple to manage dynamic schedules and calendars without syntax errors.

1. Open your data file: Launch WPS Spreadsheet and open your existing schedule document.
2. Input the date formula: Click into the target schedule cell and type `=IF(D2="","",D2+14)`.
3. Adjust cell formatting: Highlight the calculated cells, go to the Home tab, click the Number Format dropdown, and select Short Date to display standard dates instead of serial numbers.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Handles date calculations, serial numbers, and complex IF logic effortlessly.Lightweight, fast-loading, and completely free to use.Familiar user interface requiring zero learning curve for Excel users.

Frequently Asked Questions

Why does my Excel date formula return a five-digit number?

Excel calculates dates using sequential serial numbers (e.g., 1 represents Jan 1, 1900). If you see a five-digit number, the math is correct, but the cell is lacking date formatting. You can fix this by selecting the cell, going to the Home tab, and changing the number format from General to Short Date.

How do I add a different number of days, like 30 or 90?

You can modify the addition part of the IF formula to fit your needs. For instance, to calculate a schedule for 30 days ahead while ignoring blanks, use `=IF(D2="","",D2+30)`.

Why do I get a #VALUE! error when adding days to a date?

This error occurs when the starting cell contains text instead of a valid date number. To resolve this, ensure that your original column is strictly formatted as dates and does not contain hidden text characters or spaces.

Excel & Data Problems