View Single Post
  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Autoincrementing dates

Hi Andrew,

Right Click on the fill handle and drag down as far as
you need when you let go of the right button at the
bottom you will be given a Menu of options.
Left click on the one you want which in this case
will be Fill Months.

HTH
Martin


"Andrew Chalk" wrote in message
...
I have a column formatted as "Date" with format March-01, etc.

If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried
A1+1 but the syntax is not understood by Excel 2003.

Many thanks.