Andy the attached gets you close, but the problem is there can be anywhere from 4-6 weeks in any given month, because you can have 1/2 weeks at both the beginning and end of a month which produces a 6 count. This is a problem of trying to force mis-matched unit of measures together.
But maybe this will get you going.
Andy.twbx.zip 1.1 MB
4 of 4 people found this helpful
Sorry for resurrecting an old post!
But in case anyone else wanted a formula based solution, this appears to work:
The basic idea is to calculate the date of the first day of each week ... then divide by 7 and take the integer part.
This is supper handy for making "calendar" styled highlight tables.