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!
VIP
Trusted Members
June 25, 2016
VIP
April 21, 2015
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).
1 Guest(s)