On Sun, 6 Nov 2005 16:12:59 -0800, "Big Rick"
wrote:

Dear Ron
Sorry it took a while to reply.
Your formula works like a dream.
In order for it to generate a 4 or 5, I have simply incorporated it into an
IF statement matching the value with another cell. I was begining to despair.
I cannot thank you enough.

Glad it worked for you. Thank you for the feedback.

By the way, one method of counting the number of weeks between two dates,
assuming your worksheet is set up as I described:

=(A2-A1)/7

will give the number of weeks form A1 to A2; and you can copy/drag the formula
down.


--ron