return date which is next higher one

Christine Menke

Hi,

I'm looking for a formula to check the "End date" and return the next higher from date from the reference sheet.

e.g. End Date is May 7, the result should be Pre-confirmed 90 LT=May 8

or End Date is June 16, the result should be Pre-confirmed 90 LT=June 26

I have no idea which formula could work.

Thanks for your help!

Nick Korna

Hi @Christine Menke,

A formula like this should work:

=INDEX([Pre-confirmed 90 LT]:[Pre-confirmed 90 LT], MATCH([End Date]@row, [Pre-confirmed 90 LT]:[Pre-confirmed 90 LT]) + 1)

Some example data:

Hope this helps, but if you've any problems/questions, then just post! 🙂