Formula to get the current weeknumber

[Ludde]

Hi

I am trying to get the weeknumber (1 to 52) out of the date. Read somewhere
that excel has a WeekNo function but I cant find it. Perhaps I got to old
version of excel (ver 2000 9.0.4402 SR-1).

Date Weekday Week YearWeek
A B C D
1 2005-09-10 Saturday 36 0536
2 2005-12-24 Saturday 51 0551
3 2006-02-07 Tuesday 06 0606
4
5
6
7


As of now I have a ownwritten formula but it doesnt handle years containing
53 weeks correctly.

How can I get the weeknumber out of the date?

/S

 

[Guest]

This topic is covered thoroughly in:

http://www.cpearson.com/excel/weeknum.htm

 

[Ron de Bruin]

See also the functions on this page if you don't want to use the ATP function
http://www.rondebruin.nl/weeknumber.htm

More info about ISO weeks you can find here
http://www.rondebruin.nl/isodate.htm