I think you forgot about Jan 1, 2005. Being on a Saturday, that counts
as week 1. Jan. 2 becomes week 2... Sept 20 is in week 39.
Enter those dates and use your formula on them to see.
Also, WEEKNUM has a parameter to determine if your weeks begin on
Sunday (1) or on Monday (2). e.g. =WEEKNUM(C18,2) means weeks begin on
Monday.
Won't change Sept. 20's week, though, as that is a Tuesday.
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=469294