I need to come up with a way to take dates in one column (C), add a year, and
show the result in the next column(D). I've come up with the following
formula: =DATE(YEAR(C2)+2,MONTH(C2),DAY(C2)), which I've placed in my D
column (first row for dates). The formula itself works, but if I don't have
a number in a particular row in my C column (say, the next or 2nd row for
dates), I get a 1901 date or, sometimes, a #VALUE error. Is there a way add
2 years to a date in one column & show the result in the next column when
there is an entry to a row, but show a blank cell when the initial date is
blank?

Many thanks...

"KA Madrigal-Young" wrote:

I need to come up with a way to take dates in one column (C), add a year, and
show the result in the next column(D). I've come up with the following
formula: =DATE(YEAR(C2)+2,MONTH(C2),DAY(C2)), which I've placed in my D
column (first row for dates). The formula itself works, but if I don't have
a number in a particular row in my C column (say, the next or 2nd row for
dates), I get a 1901 date or, sometimes, a #VALUE error. Is there a way add
2 years to a date in one column & show the result in the next column when
there is an entry to a row, but show a blank cell when the initial date is
blank?

Many thanks...