Autofill

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mrich - 22 Jun 2006 01:15 GMT

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.

Reply to this Message

Dave Peterson - 22 Jun 2006 01:40 GMT

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)

> 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
[quoted text clipped - 7 lines]
> Any and all suggestions will be greatly appreciated.
> Thanks in advance.

Signature

Dave Peterson

Reply to this Message

Mrich - 22 Jun 2006 02:13 GMT

Wonderful. That works.
Thanks very much.

> Put the date in the top cell (say A1).
> Put the =A1 in the next cell (A2).
[quoted text clipped - 19 lines]
>> Any and all suggestions will be greatly appreciated.
>> Thanks in advance.

Reply to this Message