View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DEQhl DEQhl is offline
external usenet poster
 
Posts: 1
Default I want to use a fill series to copy down a pattern of dates.

I want to use fill series to copy a pattern of dates down a column. The catch
is that I want it to have a date show up three times in a row, in separate
cells. So the end products would have three of the same date in the first
three column cells, three of the next date in the next three column cells,
and so on for an entire year. I can't seem to get the fill series to follow
the pattern as all it do is copy the above cells.