View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
B.G. - Canada B.G. - Canada is offline
external usenet poster
 
Posts: 1
Default Consecutive dates using two cells at a time.

I want cells a1 and a2 to have a date of Jan. 1/09 then have cells a3 and a4
to be Jan.2/09 etc.. in this consecutive pattern for the entire year. Is
there any fast way to accomplish this other than manualy entering the date
two cells at a time? Any help much appreciated!