Hello,

I want a date to show up in a column if another column has "safety certification" or "safety mid-year certification" in it but if it doesn't have either or those then to remain blank. I think using the IF function is probably how to do it but I so far haven't been able to get it to work.

In other words.

If C3 is "Safety Certification or safety mid-year certification" then E3 = date in D3 + 6 months

Any help with is appreciated,

Thanks,
Mike