Salut bien,
Un seul chiffre à changer mettre +30 au lieu +15
Bruno
Sub nouveau()
rep = InputBox("entrez la date de d?part")
If rep = "" Then Exit Sub
On Error Resume Next
j = CDate(rep)
If Err <> 0 Then MsgBox "date non valable": Exit Sub
lig = [D65000].End(3).Row + 2
[C5:U9].Copy Range("C" & lig)
Cells(lig, 4) = j
Cells(lig + 1, 4) = "": Cells(lig + 2, 5) = ""
For k = 5 To 21
j = Cells(lig, k - 1) + 30 '''''''ici 30 au lieu de 15
For a = 0 To 6
If Weekday(j + a) = 3 Or Weekday(j + a) = 6 Then
Cells(lig, k) = j + a
Exit For
End If
Next
Next
End Sub