| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date serial
How do I get today's date as a serial into a variable?
dim dDate as Date dDate = serial NOW() Of course the above does not work. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date serial
try:
Sub aa() Dim serdate As Long serdate = DateValue(Now) End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date serial
dim lDate as long ldate = clng(date) Striker wrote: How do I get today's date as a serial into a variable? dim dDate as Date dDate = serial NOW() Of course the above does not work. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| A VBA function to give serial date for date and time? | Excel Programming | |||
Hybrid Mode
