[RESOLVED] [Excel] Need to read date data as date problem

[RobDog888]

So I get this excel sheet (*.xls) from another company and reading it in to our system, no problems until I get to a few specific cells where they have dates. The dates are not date formatted cells nor text. When I look (right click . cell formatting... ) it doesnt show any formatting at all. When I read in the cells they read in as NULL. I cannot manually reformat the cells to date format as its all for an automated process dealing with many files every day.

Anyone have any tips on reading date data that reads in as null?

Thanks

Ps, I am connecting to it via OleDb in C# 2015 for a website project and the sheet is read in to a datatable.

order.DateLienFiled = string.IsNullOrEmpty(dt.Rows[7].ItemArray[13].ToString()) ? 
    (DateTime?)null :
            Convert.ToDateTime(dt.Rows[7].ItemArray[13].ToString());