Sub Tri()
Dim T, T2(), i%, j%
Application.ScreenUpdating = False
T = Range("B4:B" & Range("B65500").End(xlUp).Row)
ReDim T2(UBound(T))
For i = 1 To UBound(T)
T(i, 1) = CDate("01/" & Month(T(i, 1)) & "/" & Year(T(i, 1)))
Next i
j = 2: T2(1) = T(1, 1)
For i = 2 To UBound(T)
If T(i, 1) <> T(i - 1, 1) Then
T2(j) = T(i, 1): j = j + 1
End If
Next i
[G3:ZZ3].ClearContents
j = 1
While T2(j) <> ""
Cells(3, j + 6) = T2(j): j = j + 1
Wend
End Sub