I need help with multiple formulas.C4 through infinity = a date (1/1/2025) and if "not blank" then "green"this is all workingD4 through infinity = the following > =DATE(YEAR(C4)+2,MONTH(C4),DAY(C4)) and if "not blank" then "red"this is all workingNow I need to make: if C4 is blank, then D4 is blankHopefully that's clear enough to get an answer. Thank you.

In D4: =IF(C4="", "", DATE(YEAR(C4)+2,MONTH(C4),DAY(C4))) or slightly shorter: =IF(C4="", "", EDATE(C4, 24))

Forum Discussion

Copper Contributor

Mar 17, 2025

Solved

I need help with multiple formulas.

C4 through infinity = a date (1/1/2025) and if "not blank" then "green"
- this is all working
D4 through infinity = the following > =DATE(YEAR(C4)+2,MONTH(C4),DAY(C4)) and if "not blank" then "red"
- this is all working

Now I need to make: if C4 is blank, then D4 is blank

Hopefully that's clear enough to get an answer. Thank you.