Date projected based on a pass/fail result

[cwcwcw]

Hi, my worksheet has a date manually entered in A1, I use the formula =EDATE(A1,6) to project the date 6 months ahead in A2. In A3 I manually enter “pass“ of “fail“. I would like the date in A2 to only be projected if A3 reads “pass“. Thank you very much.

 

[Trebor76]

Hi there,

So in cell A2 you'd the following:

=IF(A3="pass",EDATE(A1,6),"")

Regards,

Robert

 

[cwcwcw]

Thanks so much, works a treat, chris

 

[Trebor76]

Thanks for letting us know and you're welcome