>Now this function always gives me 5....but months not always have 5 (the most have 4...)..i.e. October gives me 5 week...and only have 4...
>
>
>CB
The main question really is, how do you define a week.
You could use the week() function for the first of the month, and the first of the next month. But complications would arise for December (you would have to know how many weeks are in the year, and add that).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)