I have a spreadsheet that has calculated dates in it. When I am reading it after loading it it crashes when calling the .DateTimeValue method on it. .DoubleValue works fine. It only crashes on the Excel cell that has a calculated date.
I can send an example Excel file if that would be helpful.