I need help with Excel - Adding dates

[Quanchi]

Hello,

I need a formula, a vb script, or some way to basically say:

12/31/2003 + 1 year = 12/31/2004


Anybody have any ideas?

Thanks in advance,

Quanchi

 

[Peo Sjoblom]

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

where A1 holds your date

 

[2rrs]

With your date in A11, you could also use: =EDATE(A11,12)