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