View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
Andrew Chalk Andrew Chalk is offline
external usenet poster
 
Posts: 12
Default Autoincrementing dates

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.