Keep an Excel Expiry Date Blank When the Start Date Is Empty
Question details
The user wants an expiry-date cell to remain blank until a start date is entered.

- 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.
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.
Use IF to leave the expiry date blank
Use this formula when the start-date cell is genuinely empty until a date is entered.
In Excel, click the cell where you want the expiry date to appear.
Type =IF(ISBLANK(C19),"",C19+24*7) in the formula bar and press Enter. Replace C19 with your start-date cell if needed.
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.

Handle a start-date formula that displays a blank
Use this version if C19 may contain a formula that returns an empty string.
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. Open the spreadsheet: Open WPS Spreadsheets and choose Open to select your workbook.
- 2. Select the expiry cell: Click the cell where the calculated expiry date should appear.
- 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. 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.

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.




