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! 🙂

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! 🙂

Christine Menke

Thanks @Nick Korna

I tried your formula and I get #No Match as result.

I first tried it with cross sheet but as this was not working I tried it first on one sheet but I get #no match.

Any idea what is my issue?

The end date varied and the "Pre-confirmed 90 LT" is a fix column.

Thanks

Nick Korna

The first thing to check: are the columns set to Date as type?

Christine Menke

Thanks @Nick Korna,

it works now also with cross sheets. Thanks a lot!

Nick Korna

No problem, glad it's resolved and working for you now. ☺️