How can I calculate the week number from a date, eg 21/06/05 = 26

cel504 · Aug 3, 2005

How can I calculate the week number from a date entered into a cel, eg
21/06/05 equals week 26 and so on in Excel.

Any advice would be appreciated.

Ron de Bruin · Aug 3, 2005

Hi

There are different week numbers

See
http://www.rondebruin.nl/weeknumber.htm
Look athe worksheet functions on that page also

And
http://www.rondebruin.nl/isodate.htm

cel504 · Aug 3, 2005

Thanks very much for your help. I have now sorted it with your help.