Day and Date Autofill

[BK]

Using Windows XP-Pro and Office 2007

I want to autofill Column A with day and date information. I only want
Tuesday, Wednesday, and Thursday. When I enter the day and date for Tuesday
in A1 and for Wednesday in A2 and for Thursday in A3, I don't seem to be
able to repeat that pattern. Selecting those three cells and then using the
autofill handle give me one of two results, neither of which is what I want.
I either get the same three day and dates repeated (instead of getting the
subsequent week's date information) or I get the rest of the week filled in
(Friday, Saturday, Sunday, etc.)

Right now I've just used the full week autofill and then I go back and
delete every Friday through Monday. Is that my best bet??

 

[Niek Otten]

In A4, enter this formula:

=A1+7

Fill down as far as you need

 

[Bob Umlas]

enter your first 3 items of Tue, Wed, Thu, then in the 4th row simply put
=A1+7 (if A1 is the first), and fill down from there.
Bob Umlas
Excel MVP

 

[T. Valko]

Another one...

Enter your first date in cell A1. It must be a Tue, Wed, or Thur.

Enter this formula in A2 and copy down as needed:

=A1+CHOOSE(WEEKDAY(A1),0,0,1,1,5)

 

[BK]

Why didn't I think of that?!?!?!

In A4, enter this formula:

=A1+7

Fill down as far as you need

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

 

[BK]

Thank you so much. I feel so stupid.

enter your first 3 items of Tue, Wed, Thu, then in the 4th row simply put
=A1+7 (if A1 is the first), and fill down from there.
Bob Umlas
Excel MVP

 

[BK]

Thanks for the response.

Another one...

Enter your first date in cell A1. It must be a Tue, Wed, or Thur.

Enter this formula in A2 and copy down as needed:

=A1+CHOOSE(WEEKDAY(A1),0,0,1,1,5)

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks for the response.