You can just enter the first two dates, select them, and then drag and copy
to get more.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"jfcby" wrote in message
ups.com...
Hello,

On worksheet2 B2 I have a date formated like 1/1/2006. I need to change
that value in yearly increments 1/1/2006, 1/1/2007, 1/1/2008 and so on.
How can the date be changed in yearly increments?

Thanks for your help in advance,
jfcby