View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Walter Mayes
 
Posts: n/a
Default Autofill a series

Excel XP

Am trying to fill a series of dates such as:


1/1
1/2
1/3
1/4
1/5


1/8
1/9
1/10
1/11
1/12

First date in cell a3. By selecting cells a1:a14 I can get Excel to
leave the two blank cells but cannot get it to skip the 1/6, 1/7 dates. In
the next series Excel picks up with the 1/6 date.Is it possible to have
Excel "skip" dates with autofill?

Walter Mayes