This little snippet here will allow you to convert excel encoded date to standard Windows DateTime.
public static DateTime ExcelDateConverter(int excelDateSerial)
{
if (excelDateSerial <>
{
excelDateSerial++;
}
return new DateTime((excelDateSerial + 693593) * (10000000L * 24 * 3600));
}
Back to Home
