Autofill
 

Howdy
New here so not sure if this is the right place to post. I searched and read
and didnt find an answer specific to my question. If i missed it please
provide a link to it. How can I autofill dates but only for alternating Wed.
and Sat.?

Thanks in advance

Autofill
 

Hi,

Enter the first 2 dates manually in A1 & A2 and then this formula in A3

=OFFSET(A3,-2,0)+7

Drag down

Mike

Then

"fretburn" wrote:

Howdy
New here so not sure if this is the right place to post. I searched and read
and didnt find an answer specific to my question. If i missed it please
provide a link to it. How can I autofill dates but only for alternating Wed.
and Sat.?

Thanks in advance

Autofill
 

Here is one way...
In A1 enter a valid Wednesday date
In A2 enter =A1+3
In A3 enter =A1+7
In A4 enter =A2+7

Select A3 and A4. Move the cursor over the lower right corner of A4. It
should change to a plus sign (+). This is the autofill cursor. Holding the
left mouse button down, drag down as far as desired to fill column A with
alternating Wednesdays & Saturdays. Finally, copy & paste in place as values.

Hope this helps,

Hutch

"fretburn" wrote:

Howdy
New here so not sure if this is the right place to post. I searched and read
and didnt find an answer specific to my question. If i missed it please
provide a link to it. How can I autofill dates but only for alternating Wed.
and Sat.?

Thanks in advance

Autofill
 

Mike,
It seems to not like my format maybe. Here are the results
11/4/2009
11/7/2009
40128

Thanks for trying.

"Mike H" wrote:

Hi,

Enter the first 2 dates manually in A1 & A2 and then this formula in A3

=OFFSET(A3,-2,0)+7

Drag down

Mike

Then

"fretburn" wrote:

Howdy
New here so not sure if this is the right place to post. I searched and read
and didnt find an answer specific to my question. If i missed it please
provide a link to it. How can I autofill dates but only for alternating Wed.
and Sat.?

Thanks in advance

Autofill
 

Tom,
That worked great.
Thanks for the help.

"Tom Hutchins" wrote:

Here is one way...
In A1 enter a valid Wednesday date
In A2 enter =A1+3
In A3 enter =A1+7
In A4 enter =A2+7

Select A3 and A4. Move the cursor over the lower right corner of A4. It
should change to a plus sign (+). This is the autofill cursor. Holding the
left mouse button down, drag down as far as desired to fill column A with
alternating Wednesdays & Saturdays. Finally, copy & paste in place as values.

Hope this helps,

Hutch

"fretburn" wrote:

Howdy
New here so not sure if this is the right place to post. I searched and read
and didnt find an answer specific to my question. If i missed it please
provide a link to it. How can I autofill dates but only for alternating Wed.
and Sat.?

Thanks in advance

Autofill
 

Sorry Mike, I was using the wrong cells. Works fine as posted. Thanks for the
help.

"fretburn" wrote:

Mike,
It seems to not like my format maybe. Here are the results
11/4/2009
11/7/2009
40128

Thanks for trying.

"Mike H" wrote:

Hi,

Enter the first 2 dates manually in A1 & A2 and then this formula in A3

=OFFSET(A3,-2,0)+7

Drag down

Mike

Then

"fretburn" wrote:

Howdy
New here so not sure if this is the right place to post. I searched and read
and didnt find an answer specific to my question. If i missed it please
provide a link to it. How can I autofill dates but only for alternating Wed.
and Sat.?

Thanks in advance