>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
That's why I wrote that this depends on how you define a week. You have at least two things to consider. Do you mean WHOLE weeks? If so, every month has 4 months, without execption. But, if the week must start at a given weekday AND you want to count the whole weeks, you must include Set("Fdow") in your formula.
Sorry, I must call it a day, but I hope I have given you some useful tips.