Need formula to calculate weekly dates in a month

[dandeisel]

Hey Guys,

I need some assistance in trying to figure out a formula for the dates in a week excluding Sundays for the whole month.

For example, I want to have a Cell for the person to input the number of the Month i.e. 9 - For September, 10 - For October.

When that is inputted in cell A1 i need cell B3 to calculate the value of the first Wed in that month. In cell E3 should input the Tuesday following in that week. I also need it to know not to include Sundays as a day in the calculation. Here's the tricky part, I need it for each week in that month.

This is a payroll sheet and our pay weeks are from Wed - Tues but were closed on Sunday

I hope you understand what I'm trying to do.
Here's a link to the spreadsheet I'm working on if you wouldn't mind looking at it and helping me.

https://docs.google.com/spreadsheets/d/1VaR2ujA0qK_FnL1kBrqe_vp0M0YpdU6LqKTzc0BLjmo/edit?usp=sharing

Thanks in advance for all your help!

 

[AhoyNC]

See if this helps.
This formula comes from Barry Houdini. See post #7 in this link.
https://www.mrexcel.com/forum/excel-questions/867109-date-listing-second-fourth-wednesdays.html

Excel Workbook
	A	B	C
1	9	= Month
2
3	1st Wed	Wednesday, September 5, 2018	Tuesday, September 11, 2018
4	2nd Wed	Wednesday, September 12, 2018	Tuesday, September 18, 2018
5	3rd Wed	Wednesday, September 19, 2018	Tuesday, September 25, 2018
6	4th Wed	Wednesday, September 26, 2018	Tuesday, October 2, 2018
Sheet

 

[dandeisel]

AhoyNC!!! You are awesome! Thank you very much that worked!

I really appreciate the time you took to do this for me.

Hope I can one day pay it forward to someone else in need of help.

All the best!
Shadi

 

[AhoyNC]

You're welcome. Thanks for the feedback. Credit for formula has to go to Barry Houdini.