Help w/formula to add 1 year to cell (date done) date due?

[Guest]

Can someone help me with a formula that would allow me to put today's date in
one cell (date done) and then add one year so that the next cell would come
up with the date one or two years from now (date due)?
Thanks
GregJ

 

[Carim]

Hi,

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

should do the job ...

HTH
Cheers
Carim

 

[Guest]

if your initial date is in A1, try
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
and format for the date style you want

 

[Guest]

Hi,

Try this: (Assuming today's date in Cell A1. B1 is for putting one year or
two years. Put this formula in C1)

=IF(B1=1,(A1+365),IF(B1=2,(A1+730+1)))

Regards,

Jaleel