adding dates with key words

I need a formula that will search a specific cell (E2) or all of column E for a “key” word and then if found, take the date in A2 and add 30 days to it and put this all in B2.

Please let me know if this can be accomplished.
Thanks. 

By: Scott

Leave a Reply

Your email address will not be published. Required fields are marked *