Day and Date Autofill

  • Thread starter Thread starter BK
  • Start date Start date
B

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??
 
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
 
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)
 
Thank you so much. I feel so stupid.



Bob Umlas said:
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
Click to expand...
 
Thanks for the response.


T. Valko said:
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)
Click to expand...
 
Back
Top