CDate(Num|$) -or- CVDate(Num|$)
Conversion
Convert to a date value.
Sub Main Debug.Print CDate(2) ' 1/1/00 End Sub