Function Problems

Update Expired Travel Dates in Excel with the Next Available Date

John WilsonJohn Wilson Nov 18, 2026 869 views

Question details

Automatically select the next available planned travel date when the current travel date has passed.

Update Expired Travel Dates in Excel with the Next Available Date
Product
Microsoft Excel
Device & OS
not provided
Scenario
A travel date is stored in C3, and available dates are listed in E3:E12.
Observed behavior
If the travel date is in the past, the result should show the earliest available date that is today or later.
Before you start

Enter the current travel date in C3 and the planned dates in E3:E12 as actual spreadsheet dates, not text. Confirm that your system date is correct because the formula uses TODAY().

Solution 1Recommended

Find the Next Available Travel Date with XLOOKUP

Use this formula in Microsoft 365 or Excel 2021 to return an upcoming date when C3 has expired.

The lookup uses TODAY(), rather than the expired date, so it cannot return another past date. The planned dates do not need to be sorted.

A formula in a separate cell displays the updated date; it does not overwrite C3 automatically.

1
Enter the formula

Select a result cell such as D3 and enter =IF(C3="","",IF(C3<TODAY(),IFERROR(XLOOKUP(TODAY(),$E$3:$E$12,$E$3:$E$12,,1),"No upcoming date"),C3)).

2
Format the result

Select D3, then choose Home > Number Format > Short Date so returned dates display as dates.

3
Apply it to other rows

Drag the fill handle from D3 down the column to check additional travel dates against the same planned-date list.

Find the Next Available Travel Date with XLOOKUP
When no future date is available: The formula displays “No upcoming date” if the list has no date on or after today. A date equal to today is considered valid.
Work with travel dates in WPS

Update Travel Dates in WPS Spreadsheets

Use a formula in WPS Spreadsheets to show the next planned date when a travel date has expired.

  1. 1. Open the workbook: Open your Excel workbook in WPS Spreadsheets and locate the travel date in C3.
  2. 2. Prepare the date list: Enter actual dates in every cell of E3:E12, select the range, and use Data > Sort to arrange it from earliest to latest.
  3. 3. Enter the formula: Select D3 and enter =IF(C3="","",IF(C3<TODAY(),IF(COUNTIF($E$3:$E$12,">="&TODAY())=0,"No upcoming date",INDEX($E$3:$E$12,COUNTIF($E$3:$E$12,"<"&TODAY())+1)),C3)). Adjust the range if your date list has a different number of entries.
  4. 4. Format and copy the result: Format D3 as a date using the Home tab, then drag its fill handle down to apply the formula to other travel dates.
Find the next available travel date using a sorted date list.Open and save Microsoft Excel XLSX files.Use familiar spreadsheet formulas and date formatting.Work with spreadsheets in the free WPS Office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the formula look up today instead of the expired date?

Looking up the expired date could return that same date or another date that has already passed. Looking up TODAY() finds the earliest listed date that is still valid.

Will the formula overwrite the original travel date?

No. Enter the formula in a separate cell, such as D3, to display the result while keeping C3 unchanged.

What happens if there are no upcoming dates?

The formulas display “No upcoming date” when E3:E12 contains no date on or after today. Add a valid planned date to the list to produce a date result.

Can I leave the result blank when the travel date is still valid?

Yes. In the Excel formula, replace the final C3 with "". The result will then be blank when the date in C3 is today or later.