Not able to retrive the date from the excel sheet.
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?
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.
