| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Consecutive dates using two cells at a time.
I want cells a1 and a2 to have a date of Jan. 1/09 then have cells a3 and a4
to be Jan.2/09 etc.. in this consecutive pattern for the entire year. Is there any fast way to accomplish this other than manualy entering the date two cells at a time? Any help much appreciated! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Consecutive dates using two cells at a time.
On Wed, 14 Jan 2009 10:52:05 -0800, B.G. - Canada <B.G. -
wrote: I want cells a1 and a2 to have a date of Jan. 1/09 then have cells a3 and a4 to be Jan.2/09 etc.. in this consecutive pattern for the entire year. Is there any fast way to accomplish this other than manualy entering the date two cells at a time? Any help much appreciated! Enter A1: 1 Jan 2009 A2: 1 Jan 2009 A3: =A1+1 Select A3:A730 Fill Down (or <ctrl-d ) --ron |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Consecutive dates using two cells at a time.
Awesome! thanks Ron!
"Ron Rosenfeld" wrote: On Wed, 14 Jan 2009 10:52:05 -0800, B.G. - Canada <B.G. - wrote: I want cells a1 and a2 to have a date of Jan. 1/09 then have cells a3 and a4 to be Jan.2/09 etc.. in this consecutive pattern for the entire year. Is there any fast way to accomplish this other than manualy entering the date two cells at a time? Any help much appreciated! Enter A1: 1 Jan 2009 A2: 1 Jan 2009 A3: =A1+1 Select A3:A730 Fill Down (or <ctrl-d ) --ron |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Consecutive dates using two cells at a time.
On Wed, 14 Jan 2009 11:31:03 -0800, B.G. - Canada
wrote: Awesome! thanks Ron! Glad to help. Thanks for the feedback. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Putting consecutive time in cells | Excel Discussion (Misc queries) | |||
| consecutive dates | Excel Discussion (Misc queries) | |||
| consecutive bi-monthly dates | Excel Worksheet Functions | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
Linear Mode
