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