Longer months with more weeks.

[rjs1943]

I need a formula to find which months have more weeks than others. I get paid every fourth Wednesday. Some months, sometimes 4 or 5, I have to wait 5 weeks between paydays, most other months I wait 4 weeks between paydays. Need a formula to tell me which months has 5 weeks between every 4th Wednesday. The rest of the months will show me 4 weeks between paydays.

Thanks:
Rich

 

[Rick Rothstein]

A slightly shorter one (based on formula from Post # 4):

="Weeks between this and next month's paydays: "&SUM(WORKDAY.INTL(EOMONTH(NOW(),{0,-1}),4,"1101111")*{1,-1})/7

"Slightly" shorter? That looks like it is a lot shorter to me. Nice going! One of these days, I will start to remember that the WORKDAY.INTL function exists in Excel and that I should make use of it.