Formula Errors

Keep an Excel Expiry Date Blank When the Start Date Is Empty

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

Question details

The user wants an expiry-date cell to remain blank until a start date is entered.

Keep an Excel Expiry Date Blank When the Start Date Is Empty
Product
Microsoft Excel
Device & OS
not provided
Scenario
Calculate an expiry date 24 weeks after the start date in cell C19.
Observed behavior
The formula =C19+24*7 can display an incorrect date when C19 is empty because Excel treats the empty cell as zero.
Before you start

Check which cell contains the start date and which cell should display the expiry date. The examples below use C19 as the start-date cell and add 24 weeks.

Solution 1Recommended

Use IF to leave the expiry date blank

Use this formula when the start-date cell is genuinely empty until a date is entered.

1
Select the expiry-date cell

In Excel, click the cell where you want the expiry date to appear.

2
Enter the IF formula

Type =IF(ISBLANK(C19),"",C19+24*7) in the formula bar and press Enter. Replace C19 with your start-date cell if needed.

3
Test and format the result

Leave C19 empty to check that the result appears blank, then enter a valid date in C19. If the result appears as a number, select the expiry cell and choose Home > Number Format > Short Date.

Use IF to leave the expiry date blank
Cells containing formulas: ISBLANK returns FALSE if C19 contains a formula, even when that formula displays an empty string. Use the alternative below for that case.
WPS Spreadsheets

Calculate expiry dates in WPS Spreadsheets

Use the same IF formula in WPS Spreadsheets to keep an expiry date blank until a start date is available.

  1. 1. Open the spreadsheet: Open WPS Spreadsheets and choose Open to select your workbook.
  2. 2. Select the expiry cell: Click the cell where the calculated expiry date should appear.
  3. 3. Enter the formula: Enter =IF(C19="","",C19+24*7) in the formula bar and press Enter. Change C19 to the appropriate start-date cell.
  4. 4. Format and test the date: Use the Home tab's number format controls to apply a date format, then enter a valid date in C19 to check the result.
Keep expiry dates blank until start dates are enteredOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and date formatting
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a date when the start-date cell is empty?

A formula such as =C19+24*7 treats an empty C19 as zero. If the result cell is date-formatted, the numeric result can appear as an unintended date.

What does 24*7 add to the start date?

It adds 168 days, or 24 weeks. Change 24 in the formula to adjust the number of weeks.

Why does ISBLANK not work when C19 looks empty?

C19 may contain a formula that returns an empty string. In the expiry cell, use =IF(C19="","",C19+24*7) to handle that case.

Why is the expiry date showing as a number?

The expiry cell may not have a date format. Select it and choose Home > Number Format > Short Date in Excel.