I am trying to set a cell to only display a date if there's a date in the reference cell. The date displayed needs to be exactly 1 year later so I'm using the following formula in cell C3:


The desired result is that if there is a date in B3, a date 1 year later will appear in C3. If there is no date in B3, C3 will remain blank.

1 Answers

Harassed Dad On

If you're typing into a cell there are no speech marks -