Weeknum returns 53 weeks?

[ThomasB]

Hi

Does anyone know why the weeknum function always returns 53 weeks instead of 52

ie 31/12/2006 = 53
31/12/2007 = 53
31/12/2008 = 53


Rgs

Thomas

 

[SteveO59L]

Cos 365 days/7 = 52.14

so there are always 52 full weeks + a partial week 53

 

[pgc01]

Also this year started on a Thursday and so the first week has only 3 days, meaning that you have 5 days in week 53, from 2009-12-27 to 2009-12-31.

 

[ThomasB]

Ahh that makes sense, that you very much for that

Rgs

Thomas

 

[barry houdini]

Cos 365 days/7 = 52.14

so there are always 52 full weeks + a partial week 53

The way WEEKNUM function works week 1 can be as short as 1 day (when 1st Jan is a Saturday) and when that co-incides with a leap year (averaging about once every 28 years) you also get a week 54, for one day only, on 31st December, e.g.

=WEEKNUM("2028-12-31")=54