Solved: 52 wks or 53 wks in Year

[gnod]

Hi,

how do i know if the year has 52 wks or 53 wks?? (in formula)..


Thanks..

[Bob Phillips]

=weeknum(DATE(YEAR(TODAY()),12,31))

[gnod]

=weeknum(DATE(YEAR(TODAY()),12,31))

when i input the formula it display #NAME?
is that a UDF you made or does the version of office affects?
i'm using Office 2k

Thanks..

[Bob Phillips]

No, it is an Analysis Toolpak function, so you need to install that.

[gnod]

No, it is an Analysis Toolpak function, so you need to install that.

Year 2000 has only 52 weeks but your formula display 53.. is there any other formula rather than using the analysis toolpak function??


Thanks..

[Bob Phillips]

It depends upon your definition of a week. MS thinks it has 53.

What is your definition?

[Brandtrock]

Here's what Chip Pearson (http://www.cpearson.com/excel/weeknum.htm) has to say about this.

Regards,

[gnod]

Thanks Brandtrock & XLD..

i use Ron de Bruin week calendar to determine if the year has 52 or 53 weeks..

http://www.rondebruin.nl/weeknumber.htm

Thanks.. :thumb