Forum Discussion
Assistance needed with function to update expired travel dates in Excel.
Hi team I am in need of some assistance regarding a function in Excel. I am looking for a way to automatically update a travel date that has already expired in a cell to the next valid date bas...
=IF(C3<TODAY(),XLOOKUP(C3,E3:E12,E3:E12,,1),"")If you work with Office 365 or Excel 2021 you can try this formula. If the planned travel date isn't in the past an empty cell is returned instead of the next possible travel date.
Thanks for your reply, appreciate it, but the formula not working for me as you can see the attached picture
=IF($C$3<TODAY(),SMALL(IF($E$3:$E$12>TODAY(),$E$3:$E$12),1),"")I assume the error is because you don't work with Office 365 or Excel 2021. An alternative could be above formula which works in my desktop Excel 2013 version. The formula has to be entered with ctrl+shift+enter if one doesn't work with Office 365 or Excel 2021.