Week numbering incorrect for 2010

[Gerhard]

Our week start on a Monday and end on Sunday. Entering the formula it display
the incorrect week number as according to the calender it starts the last
week of 2009. Is there a fix for this problem?

 

[Jan Karel Pieterse]

Hi Gerhard,

Our week start on a Monday and end on Sunday. Entering the formula it display
the incorrect week number as according to the calender it starts the last
week of 2009. Is there a fix for this problem?

You probably live outside of the USA and use the ISO weeknumbering system. The
WEEKNUM formula returns the US weeknumber.

This formula returns the weeknumber belonging to a date in cell A2:

=1+INT((A2-DATE(YEAR(A2+4-WEEKDAY(A2+6)),1,5)+WEEKDAY(DATE(YEAR(A2+4-WEEKDAY(A2+
6)),1,3)))/7)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com