Private Sub MAJPiquets()
Application.Calculation = xlCalculationManual
Dim gardedujour As String
Dim j As Integer
Dim jourgarde As Date
Sheets("Piquets2").Activate
For j = 122 To 131
jourgarde = Cells(j, 1)
jourgarde = Format(jourgarde, "dd/mm/yyyy")
gardedujour = ThisWorkbook.Path & "\" & Format(jourgarde, "yyyy") & "\" & Format(jourgarde, "mmmmyyyy")
'chef de garde
Cells(j, 2) = "='" & gardedujour & "\[" & Format(jourgarde, "ddmmmmyyyy"".xls") & "]01'!$W$4"
'stationnaire
Cells(j, 4) = "='" & gardedujour & "\[" & Format(jourgarde, "ddmmmmyyyy"".xls") & "]01'!$AW$4"
Next j
End Sub