| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with Dates - and odd request
Many thanks Sir, you help was much appreciated!
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
