Help with Dates - and odd request
 

Hi,

I need a to end up with the following..

01/01/06
01/01/06
02/01/06
02/01/06
03/01/06
03/01/06
......going al the way down to 31/12/10

Can anyone suggest a formula to achiece this ?

Thanks in advance,
Ash

Help with Dates - and odd request
 

Put 01/01/06 in A1 and A2, then in A3 put the formula
=A1+1
Format A3 as date and copy down as far as you need
(A3652 I think)

Andrew



Ash wrote:
Hi,

I need a to end up with the following..

01/01/06
01/01/06
02/01/06
02/01/06
03/01/06
03/01/06
.....going al the way down to 31/12/10

Can anyone suggest a formula to achiece this ?

Thanks in advance,
Ash

Help with Dates - and odd request
 

Many thanks Sir, you help was much appreciated!

Help with Dates - and odd request
 

Cell A4 should have =A3 before
copying A3 and A4 (Combined) down.


"Andrew Taylor" wrote in message
oups.com...
Put 01/01/06 in A1 and A2, then in A3 put the formula
=A1+1
Format A3 as date and copy down as far as you need
(A3652 I think)

Andrew



Ash wrote:
Hi,

I need a to end up with the following..

01/01/06
01/01/06
02/01/06
02/01/06
03/01/06
03/01/06
.....going al the way down to 31/12/10

Can anyone suggest a formula to achiece this ?

Thanks in advance,
Ash

Help with Dates - and odd request
 

"Jim May" wrote in message
news:BFqZf.55269$KE1.37170@dukeread02...
"Andrew Taylor" wrote in message
oups.com...

Ash wrote:
Hi,

I need a to end up with the following..

01/01/06
01/01/06
02/01/06
02/01/06
03/01/06
03/01/06
.....going al the way down to 31/12/10

Can anyone suggest a formula to achiece this ?

Put 01/01/06 in A1 and A2, then in A3 put the formula
=A1+1
Format A3 as date and copy down as far as you need
(A3652 I think)

Cell A4 should have =A3 before
copying A3 and A4 (Combined) down.

Am I confused, Jim?
What's wrong with Andrew's suggestion? Copying A3 down would put =A2+1 into
A4, wouldn't it?
--
David Biddulph

Help with Dates - and odd request
 

I should have said:
Besides A3 containing =A1+1
Cell A4 should also first contain =A3 before
Highlighting cells A3 and A4 and with the
right-bottom handle on cell A4 Drag and FILL Down to A3652.

Hope that is CLEARER.
Jim

"David Biddulph" wrote in message
...
"Jim May" wrote in message
news:BFqZf.55269$KE1.37170@dukeread02...
"Andrew Taylor" wrote in message
oups.com...

Ash wrote:
Hi,

I need a to end up with the following..

01/01/06
01/01/06
02/01/06
02/01/06
03/01/06
03/01/06
.....going al the way down to 31/12/10

Can anyone suggest a formula to achiece this ?

Put 01/01/06 in A1 and A2, then in A3 put the formula
=A1+1
Format A3 as date and copy down as far as you need
(A3652 I think)

Cell A4 should have =A3 before
copying A3 and A4 (Combined) down.

Am I confused, Jim?
What's wrong with Andrew's suggestion? Copying A3 down would put =A2+1
into A4, wouldn't it?
--
David Biddulph