return date which is next higher one
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!
Help Article Resources
Check out the Formula Handbook template!