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