Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionFunction GetLundi(Byval wn as long, byval Y as long) as Date GetLundi = DateAdd("ww", wn - 1, CDate("01/01/" & y)) - Weekday(CDate("01/01/" & y)) + 2 End Function
Function GetWeekFirstDay(ByVal vnWeek As Long, ByVal vnYear As Long) As Date Dim dFirstJan As Date dFirstJan = DateSerial(vnYear, 1, 1) GetWeekFirstDay = DateAdd("d", 7 * (vnWeek - 1), dFirstJan) - _ Weekday(dFirstJan, vbUseSystemDayOfWeek) + 1 If dFirstJan > GetWeekFirstDay Then GetWeekFirstDay = GetWeekFirstDay + 7 End If End Function