'Declaration
 
Function DateTimeToNumber( _
   ByVal dateTime As System.Date _
) As System.Double

'Usage
 
Dim instance As IWorkbook
Dim dateTime As System.Date
Dim value As System.Double
 
value = instance.DateTimeToNumber(dateTime)

System.double DateTimeToNumber( 
   System.DateTime dateTime
)

Parameters

dateTime

The System.DateTime instance to convert.

Return Value

Dates and times are stored in worksheet cells as a date-time serial number.

This method is safe to use from custom functions.

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IWorkbook Interface
IWorkbook Members
NumberToDateTime Method
Date1904 Property