Forum Discussion
help please
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 se...
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.
