I would like to use Excel's autofill feature to fill two dates down a column for the year 2017. I need the date for Tuesday, January 3rd, 2017 and Wednesday, January 4th, 2017. I would then like to repeat the sequence for every Tuesday and Wednesday for the rest of the year. Your help is appreciated!
Hi David
Can you settle for a formula instead of an auto-fill?
A1: 03/01/2017
A2: 04/01/2017
A3: =A1+7
Copy A3 down as far as you want.
Sunny
I think Sunny has the most simple and efficient solution for this case. But I wondered maybe David wants a weeklist and then only the Tuesdays and Wednesdays filled in with a color or such. Let us hear about that, and then you can use the conditional formatting.
Other solution I thought of was the formula 'WORKDAY.INTL'.
You can give the first date in A1 as Sunny did.
In A2 the formula is =WORKDAY.INTL(A1,1,"1001111").
Set the celformat to date and copy down as much as you like and you only get the Tuesdays and Wednesdays.
I only recently 'discovered' that you can ad or omit days with the seven 1's or 0's where the 1's are omitted (starting the Monday) and the zero's are counted (so here the Tuesday and Wednesday).
Very interesting, Frans 
. I will definitely keep this in my toolkit for future use.
Thanks for sharing.
Sunny
Very nice, Frans. Thanks for sharing.
Mynda
