help please

Copper Contributor

I'm trying to create a formula that will populate a cell (G1) with a date , using the date in A1 and add days (7,30,7,30)  creating a date format, dependent upon H1 which will have a corresponding series of responses ( Urgent, none urgent, for info, medium)


I'm going round in circles 


Can anyone help me please?

2 Replies


In G1:


=IF(OR(A1="", H1=""), "", A1+IF(OR(LOWER(H1)={"urgent", "for info"}), 7, 30))


Format G1 as a date.

Fill down if required.

Can you pls share a screenshot of your file or Can you pls explain how & when to add days (7,30,7,30). Also, confirm how the dates in G1 should be related to H1  ( Urgent, none urgent, for info, medium) @dilitch