"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