Re,
A tester en fonction des données réelles.
Cdlt
Option Explicit
'----------------------------------------------------------------
'Les dates sont des dates.
Public Sub AjoutUnJourNum()
Dim Ws As Worksheet
Dim derLigne As Long, i As Long
Application.ScreenUpdating = False
Set Ws = Worksheets("Feuil2")
With Ws
derLigne = .Range("B" & Rows.Count).End(xlUp).Row
For i = 7 To derLigne
.Cells(i, 2) = serieJO(.Cells(i, 2), 1)
.Cells(i, 2).NumberFormat = "ddd dd/mm"
Next
End With
Set Ws = Nothing
End Sub
'----------------------------------------------------------------
'Les dates ne sont pas des dates mais du texte (format jjj jj/mm)
Public Sub AjoutUnJourTexte()
Dim Ws As Worksheet
Dim derLigne As Long, i As Long
Dim d As Date
Application.ScreenUpdating = False
Set Ws = Worksheets("Feuil2")
With Ws
derLigne = .Range("B" & Rows.Count).End(xlUp).Row
For i = 7 To derLigne
d = CDate(Right(.Cells(i, 2), 5))
.Cells(i, 2) = serieJO(d, 1)
.Cells(i, 2).NumberFormat = "ddd dd/mm"
Next
End With
Set Ws = Nothing
End Sub
'----------------------------------------------------------------
Public Function serieJO(d As Date, n As Integer) As Date
If IsEmpty(d) Or IsEmpty(n) Or Not IsDate(d) Then Exit Function
serieJO = Application.WorksheetFunction.WorkDay(d, n)
End Function