Sub FaireReduireAFeuDoux()
Dim an, pja As Date, pma As Date
an = InputBox("Saisir l'année,svp", "Choix de l'année", Year(Date))
pja = DateSerial(an, 1, 1): pma = (pja - Day(pja) + 1) + Choose(Weekday(pja), 2, 1, 0, 6, 5, 4, 3)
[A1] = pma + 7: [A1:A26].DataSeries 2, 3, 1, 14
End Sub