Returning a date as a serial umber

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a datetime as a variant variable. How can I format
it as the equivalent serial number?
 
Sub test()
Dim D As Date
D = Now
MsgBox Format(D, "General Number")
End Sub

(You should use a Date and not a Variant if Datetime is what it's filed with
at all times)
 
Back
Top