Question description:
This user has given permission to use the problem statement for this
blog.
I have a date column and would like to post consecutive Wednesdays by calendar date
Solved by B. U. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
15/08/2018 - 07:44
Hi, how are you doing today?
Excelchat Expert
15/08/2018 - 07:46
I just wan to confirm I understood your questions. You would like to create a column that has dates with successive wednesdays
Excelchat Expert
15/08/2018 - 07:47
for instance today is wed 8/25/2018 and the next row down in that column would have wed 8/22/2018
Excelchat Expert
15/08/2018 - 07:47
Is that correct?
Excelchat Expert
15/08/2018 - 07:50
The way I would approach this is through simple addition to the date you are starting with
Excelchat Expert
15/08/2018 - 07:52
in Excel you can add to the dates with simple addition (here date + 7)
Excelchat Expert
15/08/2018 - 07:52
So in B2 we have the date entered
Excelchat Expert
15/08/2018 - 07:53
In B3 we have the formula "=B2+7" which gives us the next Wednesday
Excelchat Expert
15/08/2018 - 07:54
Then the formula can be dragged down to populate the rest of the column with only wednesdays
Excelchat Expert
15/08/2018 - 07:55
Does that answer your question?
Excelchat Expert
15/08/2018 - 07:55
I'll give you a few minutes to respond.
Excelchat Expert
15/08/2018 - 07:57
Ok, well if you don't have any further questions. I hope this was able to solve your question. I hope you come back to use Got It Pro again soon. Have a nice day!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
