Forum Discussion
Look for a date after a specific cell date
Hi there, Can someone please help to calculate the following. Look for the date we go OOS, and then give me the next receipt date after that date. I currently have the following in place to...
Hi Ana_H123
it's not completely clear to me what all the columns mean. If I understand correctly, the OOS date gets already calculated correctly (in column CX of your screenshot).
And you are basically searching the first (blue) row for the OOS date and pick the next date that follows this date. Is that correct?
I was able to solve this one with the following formula
=IFERROR(IF(CX13="OK","",INDEX($S$1:$CR$1,1,SMALL(IF(($S$1:$CR$1>$CX13)*($S11:$CR11>0),COLUMN($S13:$CR13)-18,""),1))),"CHECK")
Thanks for your help though