Calculate Days Between Dates in Excel and Ignore Blank Approval Dates
Question details
Calculate the days between a renewal's received date and approval date only when an approval date has been entered.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Track elapsed approval time for renewals while leaving the calculation blank for open renewals.
- Observed behavior
- Approved renewals should display the elapsed number of days; renewals without an approval date should display a blank result.
Check that the received and approval dates are actual spreadsheet dates rather than text. If you use an Excel table, confirm the exact column headers before entering the structured-reference formula.
Use IF and DAYS in an Excel table
Use this formula when renewal records are stored in an Excel table with named date columns.
Click the first data cell in the table column where you want to show elapsed approval days.
Enter =IF([@[Date Approved]]="","",DAYS([@[Date Approved]],[@[Date Received]])) and press Enter. Replace the header names if your table uses different labels.
If the approval column is named Approved - Date, use =IF([@[Approved - Date]]="","",DAYS([@[Approved - Date]],[@[Date Received]])) instead.
Check a row with an approval date and a row without one. Excel normally fills the formula down the table's calculated column; the open renewal should display a blank result.

Use cell references for a regular worksheet range
Use this version if your records are not stored in an Excel table.
Track Approval Days in WPS Spreadsheets
Use IF and DAYS in WPS Spreadsheets to show elapsed calendar days only after an approval date is entered. A cell-reference formula keeps open renewals visually blank.
- 1. Open your renewal worksheet: Launch WPS Spreadsheets and use Menu > Open to open your Excel workbook, or create a new spreadsheet.
- 2. Locate the date columns: Identify the received and approval date cells. In this example, A2 contains Date Received and B2 contains Date Approved.
- 3. Enter the elapsed-day formula: Click C2 and enter =IF(B2="","",DAYS(B2,A2)). Press Enter to display the elapsed days or a blank result.
- 4. Apply the formula to all records: Drag C2's fill handle down the result column. Select the results and choose Home > Number Format > Number or General if they appear as dates.

Frequently Asked Questions
Why does the formula leave open renewals blank?
The IF test checks whether the approval date equals an empty string. If it does, the formula returns ""; otherwise, DAYS calculates the difference between the approval and received dates.
What if my approval column is named Approved - Date?
In the Excel table's result column, enter =IF([@[Approved - Date]]="","",DAYS([@[Approved - Date]],[@[Date Received]])). Structured references must match your table's column headers.
How do I prevent a calculation when the received date is also blank?
For a regular range with the received date in A2 and approval date in B2, enter =IF(OR(A2="",B2=""),"",DAYS(B2,A2)) in the result cell and fill down.
Why does the result show a date or a negative number?
If it shows a date, select the result cells and choose Home > Number Format > Number or General. A negative number means the approval date is earlier than the received date; check the source dates and make sure the approval date is the first argument in DAYS.
Does DAYS exclude weekends and holidays?
No. DAYS returns calendar days. To count workdays instead, use NETWORKDAYS with the same blank-date check, such as =IF(B2="","",NETWORKDAYS(A2,B2)). NETWORKDAYS counts eligible start and end dates inclusively and can also accept a holiday range.




