ExcelDateToDateTime(Workbook,Double) Method

Converts Excel's numerical representation of a date to a DateTime.

Syntax

Visual Basic

'Declaration
 
Public Overloads Shared Function ExcelDateToDateTime( _
   ByVal workbook As Workbook, _
   ByVal excelDate As Double _
) As Nullable(Of Date)

C#

public static Nullable<DateTime> ExcelDateToDateTime( 
   Workbook workbook,
   double excelDate
)

Parameters

workbook

excelDate

The Microsoft Excel date format which should be converted to a DateTime.

Remarks

When using the 1900 date system in Excel, dates before 3/1/1900 must be corrected, because Excel incorrectly assumes 1900 is a leap year. This overload assumes the 1900 date system is being used as so it corrects the date values.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, 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