I am using the following formula to calculate the calendar week if referenced to a cell with date:
=INT((A1-DATE(YEAR(A1);1;1)-WEEKDAY(A1))/7)+2
but it does not work properly. If I enter 24.08.2012
I get calendar week 35 but it is actually 34.
Does anyone know what is going wrong?