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,
AshPut 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:
gt; Hi,
gt;
gt; I need a to end up with the following..
gt;
gt; 01/01/06
gt; 01/01/06
gt; 02/01/06
gt; 02/01/06
gt; 03/01/06
gt; 03/01/06
gt; .....going al the way down to 31/12/10
gt;
gt; Can anyone suggest a formula to achiece this ?
gt;
gt; Thanks in advance,
gt; AshMany thanks Sir, you help was much appreciated!Cell A4 should have =A3 before
copying A3 and A4 (Combined) down.quot;Andrew Taylorquot; gt; wrote in message oups.com...
gt; Put 01/01/06 in A1 and A2, then in A3 put the formula
gt; =A1 1
gt; Format A3 as date and copy down as far as you need
gt; (A3652 I think)
gt;
gt; Andrew
gt;
gt;
gt;
gt; Ash wrote:
gt;gt; Hi,
gt;gt;
gt;gt; I need a to end up with the following..
gt;gt;
gt;gt; 01/01/06
gt;gt; 01/01/06
gt;gt; 02/01/06
gt;gt; 02/01/06
gt;gt; 03/01/06
gt;gt; 03/01/06
gt;gt; .....going al the way down to 31/12/10
gt;gt;
gt;gt; Can anyone suggest a formula to achiece this ?
gt;gt;
gt;gt; Thanks in advance,
gt;gt; Ash
gt;
quot;Jim Mayquot; gt; wrote in message
news:BFqZf.55269$KE1.37170@dukeread02...
gt; quot;Andrew Taylorquot; gt; wrote in message
gt; oups.com...

gt;gt; Ash wrote:
gt;gt;gt; Hi,
gt;gt;gt;
gt;gt;gt; I need a to end up with the following..
gt;gt;gt;
gt;gt;gt; 01/01/06
gt;gt;gt; 01/01/06
gt;gt;gt; 02/01/06
gt;gt;gt; 02/01/06
gt;gt;gt; 03/01/06
gt;gt;gt; 03/01/06
gt;gt;gt; .....going al the way down to 31/12/10
gt;gt;gt;
gt;gt;gt; Can anyone suggest a formula to achiece this ?

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

gt; Cell A4 should have =A3 before
gt; 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
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

quot;David Biddulphquot; gt; wrote in message
...
gt; quot;Jim Mayquot; gt; wrote in message
gt; news:BFqZf.55269$KE1.37170@dukeread02...
gt;gt; quot;Andrew Taylorquot; gt; wrote in message
gt;gt; oups.com...
gt;
gt;gt;gt; Ash wrote:
gt;gt;gt;gt; Hi,
gt;gt;gt;gt;
gt;gt;gt;gt; I need a to end up with the following..
gt;gt;gt;gt;
gt;gt;gt;gt; 01/01/06
gt;gt;gt;gt; 01/01/06
gt;gt;gt;gt; 02/01/06
gt;gt;gt;gt; 02/01/06
gt;gt;gt;gt; 03/01/06
gt;gt;gt;gt; 03/01/06
gt;gt;gt;gt; .....going al the way down to 31/12/10
gt;gt;gt;gt;
gt;gt;gt;gt; Can anyone suggest a formula to achiece this ?
gt;
gt;gt;gt; Put 01/01/06 in A1 and A2, then in A3 put the formula
gt;gt;gt; =A1 1
gt;gt;gt; Format A3 as date and copy down as far as you need
gt;gt;gt; (A3652 I think)
gt;
gt;gt; Cell A4 should have =A3 before
gt;gt; copying A3 and A4 (Combined) down.
gt;
gt; Am I confused, Jim?
gt; What's wrong with Andrew's suggestion? Copying A3 down would put =A2 1
gt; into A4, wouldn't it?
gt; --
gt; David Biddulph
gt;