Function WOY (MyDate As Date) As Integer ' Week Of Year
'---http://support.microsoft.com/kb/200299/fr
WOY = Format(MyDate, "ww", vbMonday, vbFirstFourDays)
If WOY > 52 Then
If Format(MyDate + 7, "ww", vbMonday, vbFirstFourDays) = 2 Then WOY = 1
End If
End Function