Getting date from Excel

[monish06 (monish)]

Hi,

I am having a following excel file I could not Read a date format field and get the exact date format data. Sheet is in protected format, I want to get the date format data from the protected sheet. how can i get the exact date format data. I have attached the excel file for reference.

TEST ITEMS1.xlsx (123.8 KB)

@Palaniyappan

[Vrushali_Gave]

@monish06 Hope this will help you

UiPath Read Date in Excel

Hi, I need to get the Date Value in excel. But i’m getting 43252 like that value. Date value in excel 1/6/2018 i want to convert 01-JUN-2019. I can’t get the actual excel date value. Thanks In Advance Muthu M

[Srini84 (Srinivas Kadamati)]

@monish06

Check below post

Tutorial : Convert Number to Date Format

[Convert Number to Date Format || UiPath || RPA UseCase] Thanks

Mark as solution if this helps

Thanks