Hi,

I have a drop down in column F with the either "Yes" "TBC" or "No",

I need help generating a formula for when Cell F4 contains the word "Yes" then Cell H4 auto populates with the date.

I also need the formula to not generate anything in H4 when F4 is blank, TBC or No.

Thanks,