Forum Discussion

Ana_H123's avatar
Ana_H123
Copper Contributor
Feb 07, 2022

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 look for the next receipt date, but it is not based on when we go out of stock, it is just the next date we receive stock. 

 

=IFERROR((INDEX($S$1:$CR$1,MATCH(CV73,S71:CR71,0))),IF(CW73<2,"CHECK","OK"))

 

 

 

Formulas and Functions

2 Replies

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Feb 07, 2022

    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?

     

    • Ana_H123's avatar
      Ana_H123
      Copper Contributor
      Feb 08, 2022

      Martin_Weiss 

       

      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

Resources