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

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

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

Hi,

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

should do the job ...

HTH
Cheers
Carim

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

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

"GregJ" wrote:

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

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

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



"GregJ" wrote:

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