Not able to retrive the date from the excel sheet.

[Preetha]

Not able to retrive the date from the excel sheet.

Excel I am using is professional 2013.

When I read a date from excel it is retriving as text hence for date 18/03/2019

it retrives as 43542.  How can can I get it in the date format?

[Preetha · Accepted solution]

Issue resolved 

I had updated the excel from standard to pro 2013. When I made changes and saved the excel and rerun the scripts the issue got some how solved.