Const Alf As String = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"
Sub DanhSoThuTuTheoNgay()
Dim WF As Object, Rng As Range, sRng As Range
Dim fDat As Date, lDat As Date, SoNgay As Integer, STT As Integer, J As Long
Dim MyFormat As String, MyAdd As String
Set WF = Application.WorksheetFunction
fDat = WF.Min(Columns("A:A")): lDat = WF.Max(Columns("A:A"))
SoNgay = lDat - fDat
Set Rng = Range([A1], [A1].End(xlDown)): Rng.Offset(1, 1).ClearContents
MyFormat = Range([A2], [A2].End(xlDown)).NumberFormat
Rng.Offset(1).NumberFormat = "MM/DD/yyyy"
For J = 0 To SoNgay
Set sRng = Rng.Find(Format(fDat + J, "MM/DD/yyyy"), , xlValues, xlWhole)
If Not sRng Is Nothing Then
MyAdd = sRng.Address: STT = 0
Do
sRng.Offset(, 1).Value = DateToStr(fDat + J) & CStr(STT)
STT = STT + 1
Set sRng = Rng.FindNext(sRng)
Loop While Not sRng Is Nothing And sRng.Address <> MyAdd
End If
Range([A2], [A2].End(xlDown)).NumberFormat = MyFormat
Next J
Rng.Offset(1).NumberFormat = MyFormat
MsgBox "Chào & Chúc Vui!"
End Sub
