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
|