|
Re: Two quick questions
> > If I enter a date in a cell then drag the fill handle down the column
> > it increased by one day each time. Is it possible to create 2 rows
> > with the same date, then the next two increase by one etc. If so, how
> > do I do it?
Another slant to the 1st Q (above) to play with ..
With an initial date in A1, say: 01-Jul-2005
Put in say, B1:
=OFFSET(Sheet1!$A$1,INT((ROWS($A$1:A1)-1)/2),)
Format B1 as date, and copy down
This will yield in col B:
01-Jul-2005
01-Jul-2005
02-Jul-2005
02-Jul-2005
03-Jul-2005
03-Jul-2005
04-Jul-2005
04-Jul-2005
05-Jul-2005
05-Jul-2005
etc
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
|