View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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