Cell to appear blank

[BecciB]

Hi There,
I need help to make a destination cell appear blank until data is entered into another cell

My formula is:
=DATE(YEAR(T2)+3,MONTH(T2),DAY(T2))

So I currently have a random date appearing in cell U2 and I would like this to remain blank until I enter data into T2.

TIA

Becci

 

[Rick Rothstein]

Hi There,
I need help to make a destination cell appear blank until data is entered into another cell

My formula is:
=IF(T2="","",DATE(YEAR(T2)+3,MONTH(T2),DAY(T2)))

So I currently have a random date appearing in cell U2 and I would like this to remain blank until I enter data into T2.

Try adding what I show in red above.

 

[BecciB]

Try adding what I show in red above.

That worked a treat, thank you very much