Update Expired Travel Dates in Excel with the Next Available Date
Question details
Automatically select the next available planned travel date when the current travel date has passed.

- 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.
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().
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.
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)).
Select D3, then choose Home > Number Format > Short Date so returned dates display as dates.
Drag the fill handle from D3 down the column to check additional travel dates against the same planned-date list.

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. Open the workbook: Open your Excel workbook in WPS Spreadsheets and locate the travel date in C3.
- 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. 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. 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.

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.




