I want to use a fill series to copy down a pattern of dates.

D

DEQhl

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.
 
S

Stephen

I'm not sure that this can be done with fill series. You can do something
similar quite easily, though.
Put the first date into the first three cells (say A1:A3). In A4 put the
formula
= A1+1
Copy this down as far as required.
If you want to convert the formula results to fixed dates, copy the column
and use
Paste Special > Values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
auto fill options (copy cell, not create series) 4
Fill handle increments year instead of day 1
How do I create a custom fill series for dates? 1
HOW DO I CREATE A SERIES INVOLVING CELLS ACROSS ROWS? 3
Formula fill across workbooks 3
Need to create a series of dates across a row 4
Fill series not working as expected 1

Top