Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc