Decide what you consider your start date to be

Heres what i did

enter a start date in A1 (01/07/2006)

in B1 enter =A1 then format it as a number (38899)

so to turn that into week numbers
I just retyped into B1
=INT((A2-38899)/7)+1


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=563275