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
Try this in E3:
=IF(OR(C3="first_phrase",C3="second_phrase"),EDATE(D3,6),"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
That worked! Thank you Ali!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks