How Many Wednesdays in a Month Where Weeknum is OddNum

[brncao]

Trying to figure out the formula for this. Type the following in column A:

Jan 2018
Feb 2018
Mar 2018
...

In column B, the formula will calculate how many Wednesdays there are in that Month where Weeknum is an odd number.
Most months have 2, but a few will have 3.

 

[Rick Rothstein]

Thank you Rick. I noticed October 2018 is returning 3 instead of 2. My paycheck is on the 10th and 24th.

You said in Message #3 the following...

My paycheck is on weeknum #1 then #3 , then #5 , etc. They're odd number.

Isn't October 3, 2018 a Wednesday in the first week of October and, hence, October 3, 17 and 31 would be the odd week number Wednesdays?

 

[brncao]

Re: How Many Wednesdays in Every Month Where Weeknum is OddNum

You said in Message #3 the following...

Isn't October 3, 2018 a Wednesday in the first week of October and, hence, October 3, 17 and 31 would be the odd week number Wednesdays?

Dave's result is the correct one. There are 3 in jan and aug.

I see what you did. You were looking at it on a month-to-month basis. Sorry if I wasn't clear.

There are 52 weeks in a year. I get paid every 2 weeks starting on week 1 that is a Wednesday (ie 1/3/2018), in other words, odd-numbered weeks. That means my last paycheck is on week 51. See Dave's result on how it should look like.

I should have a total of 26 paychecks per year (27 in 2020). Let me know if you're still unsure.

Thanks