| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a custom fill series for dates?
I want to create a custom fill series for dates. Example: For the first
four (4) cells I want 5-1-07, the next four (4) cells I want 5-2-07, the next four (4) cells in want 5-3-07,... I want this to continue in series for as long as I drag down "the fill handle". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a custom fill series for dates?
One way ..
Put in any starting cell, eg in B2: = --"5Jan2007"+INT((ROW(A1)-1)/4) Format B2 as date to taste, then copy down as far as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jeff" wrote: I want to create a custom fill series for dates. Example: For the first four (4) cells I want 5-1-07, the next four (4) cells I want 5-2-07, the next four (4) cells in want 5-3-07,... I want this to continue in series for as long as I drag down "the fill handle". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel fill series | New Users to Excel | |||
| Fill series Q1, Q2, Q3, Q4 | Excel Discussion (Misc queries) | |||
| How To: Easy Box Plot | Charts and Charting in Excel | |||
| Upper / Fill Series Function in Excel | Excel Discussion (Misc queries) | |||
| fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) | |||
Hybrid Mode
