I am using the following formula to calculate the calendar week if referenced to a cell with date:
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?