Forum Discussion
Solved
Formula Help
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),...
In D4:
=IF(C4="", "", DATE(YEAR(C4)+2,MONTH(C4),DAY(C4)))
or slightly shorter:
=IF(C4="", "", EDATE(C4, 24))
In D4:
=IF(C4="", "", DATE(YEAR(C4)+2,MONTH(C4),DAY(C4)))
or slightly shorter:
=IF(C4="", "", EDATE(C4, 24))
Thank you.