View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jfcby[_2_] jfcby[_2_] is offline
external usenet poster
 
Posts: 121
Default Change cell value Excel 2000 & 2003

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