Option Explicit
Private ExecInduite As Boolean
Private Sub ComboBox1_Change(): If ExecInduite Then Exit Sub
Dim Dt As Date
Dt = CDate(Mid$(ComboBox1.Text, InStr(ComboBox1.Text, " ") + 1))
ComboBox1.LinkedCell = ""
With [C2]: .NumberFormat = "dddd dd mmm yyyy": .Value = Dt: End With
ExecInduite = True
ComboBox1.Value = Format(Dt, "dddd dd mmm yyyy")
ExecInduite = False
End Sub