Weeks per month

[trosasco23]

Hello.. this should be simple but somehow stressful for me.. I need to find out the number of weeks per a certain month.

For example:
in A1 - i have a date (4/14/2016)
in A2 i have the formula that says APRIL
so in A3 I would like to say 5 (for 5 weeks in April..

Is there a simple formula for this?

[oeldere]

date month week
1-4-2016 4 14

a1=01-04-2016
b1=month(a1)
c1=weeknumber(a1)

all data drag down.

after that i made a pivot table and see that april has 5 week / may has 5 weeks

[oeldere]

duplicated post

[JeteMc]

Also you might want to try this formula in A3:

Please Login or Register  to view this content.

Let me know if you have any questions.

[trosasco23]

JeteMc is it possible that this formula is off just a little? I checked on 7/14/2016 and the formula returns 6 weeks...I made it look for the actual date.. I guess maybe I need how many work weeks?

oeldere... Thank you but I think that is too long of a process.. I would like to stay away from adding a pivot.

[Pete_UK]

Here's another one:

=ROUNDUP(DAY(EOMONTH(A1,0))/7,0)

Hope this helps.

Pete

[JeteMc]

The 1st of July is near the end of the 27th week of the year and the 31st of July starts the 32nd week of the year. So counting weeks the formula takes into account 27, 28, 29, 30, 31 and 32 which is (at least part of) 6 different weeks.

[trosasco23]

Thank you guys. I ended up doing a vlookup.

[JeteMc]

Glad that you got a solution that works for you. Thank you for marking the thread 'Solved' so members will not feel compelled to keep looking to see if additional help is needed. I hope that you have a good day.