Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use a fill series to copy down a pattern of dates.
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. "DEQhl" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto fill options (copy cell, not create series) | Excel Discussion (Misc queries) | |||
How do I create a custom fill series for dates? | Excel Discussion (Misc queries) | |||
Auto Fill Links with a Pattern | Excel Discussion (Misc queries) | |||
fill a series of dates excluding holidays | Excel Worksheet Functions | |||
excel auto fill needs to be have default action (series,copy...) . | Excel Discussion (Misc queries) |