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?