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!

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

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

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