I would like to autofill dates in a row which I know how to do but what I
need to do is have the same date in 2 cells before progressing on the the
next date and so on.
For example, I need this :
04/01/06
04/01/06
04/02/06
04/02/06
etc......
Any and all suggestions will be greatly appreciated.
Thanks in advance.

Put the date in the top cell (say A1).
Put the =A1 in the next cell (A2).
Put this in A3: =A1+1
put this in A4: =a1+1

Select A3:A4 and copy those cells down.

Select the range of cells
edit|copy
edit|paste special|values
(if you don't want the formulas)

Mrich wrote:

I would like to autofill dates in a row which I know how to do but what I
need to do is have the same date in 2 cells before progressing on the the
next date and so on.
For example, I need this :
04/01/06
04/01/06
04/02/06
04/02/06
etc......
Any and all suggestions will be greatly appreciated.
Thanks in advance.

--

Dave Peterson

Wonderful. That works.
Thanks very much.
"Dave Peterson" wrote in message
...
Put the date in the top cell (say A1).
Put the =A1 in the next cell (A2).
Put this in A3: =A1+1
put this in A4: =a1+1

Select A3:A4 and copy those cells down.

Select the range of cells
edit|copy
edit|paste special|values
(if you don't want the formulas)

Mrich wrote:

I would like to autofill dates in a row which I know how to do but what I
need to do is have the same date in 2 cells before progressing on the the
next date and so on.
For example, I need this :
04/01/06
04/01/06
04/02/06
04/02/06
etc......
Any and all suggestions will be greatly appreciated.
Thanks in advance.

--

Dave Peterson