Forum Discussion

dilitch's avatar
dilitch
Copper Contributor
Oct 08, 2023

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 series of responses ( Urgent, none urgent, for info, medium)

 

I'm going round in circles 

 

Can anyone help me please?

  • 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 

  • dilitch 

    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.

Resources