Calculation Issues

Calculate Days Between Dates in Excel and Ignore Blank Approval Dates

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 868 views

Question details

Calculate the days between a renewal's received date and approval date only when an approval date has been entered.

Calculate Days Between Dates in Excel and Ignore Blank Approval Dates
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.
Before you start

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.

Solution 1Recommended

Use IF and DAYS in an Excel table

Use this formula when renewal records are stored in an Excel table with named date columns.

1
Select the result cell

Click the first data cell in the table column where you want to show elapsed approval days.

2
Enter the conditional formula

Enter =IF([@[Date Approved]]="","",DAYS([@[Date Approved]],[@[Date Received]])) and press Enter. Replace the header names if your table uses different labels.

3
Match alternate approval headers

If the approval column is named Approved - Date, use =IF([@[Approved - Date]]="","",DAYS([@[Approved - Date]],[@[Date Received]])) instead.

4
Verify the calculated results

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 IF and DAYS in an Excel table
Calendar days, not business days: DAYS subtracts the received date from the approval date and includes weekends and holidays. The empty-string result looks blank, but the cell still contains a formula.
Calculate renewal approval time

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. 1. Open your renewal worksheet: Launch WPS Spreadsheets and use Menu > Open to open your Excel workbook, or create a new spreadsheet.
  2. 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. 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. 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.
Keep elapsed-day results blank for renewals awaiting approval.Calculate calendar days with familiar IF and DAYS functions.Open and save Microsoft Excel .xlsx and .xls files.Fill the formula down to track multiple renewal records.
microsoft office alternative - wps office

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.