Format Dates in Excel with VBA

Many Excel users find it difficult to automate the formatting of dates. Although using standard methods to format dates in Excel is quite straight forward, the automation of formatting dates requires the use of VBA. Watch the training video below to see how we can format dates in Excel quickly and easily with VBA using ‘number format’ and a looping process:

You can view this video on YouTube.

Here’s the complete VBA code:

Sub formatDates()
Dim lastrow As Long
lastrow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
‘MsgBox lastrow
For i = 2 To lastrow
‘Cells(i, 2).NumberFormat = (“dd-mm-yyyy”)
‘Cells(i, 2).NumberFormat = (“mm-dd-yyyy”)
‘Cells(i, 2).NumberFormat = (“ddd-mm-yyyy”)
Cells(i, 2).NumberFormat = (“mm-ddd-yyyy”)
Next i
End Sub


Leave a Reply

Your email address will not be published. Required fields are marked *