| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning a date as a serial umber
I have a datetime as a variant variable. How can I format
it as the equivalent serial number? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Returning a date as a serial umber
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) -- HTH. Best wishes Harald Followup to newsgroup only please "David" skrev i melding ... I have a datetime as a variant variable. How can I format it as the equivalent serial number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Serial Date n+2 +2 +3 +2 +2 +3... | Excel Discussion (Misc queries) | |||
| Date String To Serial | Excel Discussion (Misc queries) | |||
| serial value to date in excel | Excel Worksheet Functions | |||
| Serial number of Date | Excel Worksheet Functions | |||
| How do I convert Date serial number to date | Excel Worksheet Functions | |||
Linear Mode
