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

[Gary''s Student]

This topic is covered thoroughly in:

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


--
Gary''s Student


"Ludde" wrote:

> 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
>
>
>

[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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
news:A77BC397-8595-495E-9213-A8BE71B2476D@microsoft.com...
> This topic is covered thoroughly in:
>
> http://www.cpearson.com/excel/weeknum.htm
>
>
> --
> Gary''s Student
>
>
> "Ludde" wrote:
>
>> 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
>>
>>
>>