I have also info on MSDN now Gary
http://msdn2.microsoft.com/en-us/library/bb277364.aspx
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Gary Keramidas" <GKeramidasATmsn.com wrote in message ...
See
http://www.rondebruin.nl/weeknumber.htm
http://www.rondebruin.nl/weeknumber.htm#information
--
Gary
"Sam" wrote in message
...
I need to find a way for vba to determine the week number of a given date in
a year. I do not want to depend on Excel's Analysis TookPak. Can anyone help?