Need a formula to show the week number of the month

Hi,

Please can anyone help me?

I need a formula to look at a date and return the week number in the month, not in the year.

For example, this month Week 1 would be 1st -4th
Week 2 5th - 11th
Week 3 12th - 18th

And so on, the maximum number of weeks would be 6 weeks. So, 7th May would just return "2".

Hope someone can help!!

Thanks

Assuming the 1st of every month will be in week 1, and that week 2 starts on the next Monday then try this formula

=INT((13-WEEKDAY(A1-1)+DAY(A1))/7)

where your date is in A1

Thanks, I'll give it a go.. What's the logic behind this formula, for future reference?