Register
Log In
Unanswered
Home
New Member
July 31, 2015
Offline
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!
Dashboards
June 25, 2016
Offline
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
Dashboards
Power BI
Power Query
April 21, 2015
Offline
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).
. I will definitely keep this in my toolkit for future use.
Most Users Ever Online: 57
Currently Online: clark shao
12 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
