Full Name:
How to: Store and Retrieve Date Values in Excel Ranges

Short Name:
How to: Store and Retrieve Date Values in Excel Ranges

Type of Entity:
C#

Abstract:
If you store a date value that falls on or after 1/1/1900 in a Microsoft Office Excel 2003 range using Microsoft Visual Studio 2005 Tools for the Microsoft Office System, it is stored in OLE Automation (OA) format. You must use the FromOADate method to retrieve the value of OLE Automation (OA) dates, If the date is earlier than 1/1/1900, it is stored as a string.

MSDN Source URL:
http://msdn2.microsoft.com/1ad4d8d6.aspx