The easiest way is to use the Text() Function.. in pure Excel you would
just do

Text("10/12/1984", "mm.dd.yyyy")

So to run it in VB, do this:

Application.Worksheetfunction.Text("10/12/1984", "mm.dd.yyyy")

Easy one liner