Well thanks guys, I was able to dig up a work around.

I am using WEEKNUM to calculate annual weeks, then use the common weeks
to gather my data on a weekly basis. When I thought about it a bit more
having it broken down into monthly work weeks wasn't exactly necessary,
the entry date just had to be in the same week (common).

WEEKNUM is a great little tool that I had not used up to this point,
but RTFM'd week number in help and it worked like a charm.

All the best!

PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=400134