How to change random date format to orginal date in excel file using VBA code in uipath

[prasath17 (Guru)]

@kaavya - Please check this post for reference…

Change format column from "General" to "Date"

@LZlz - here you go… ConvertOADate_LZ.xaml (5.8 KB) Output: Test_LZ.xlsx (9.0 KB) Hope this helps… Note: When you are running the real file, you have to make sure you don’t have any blank values in that column. or else the conversion will fail. If you have blank values in the column then you have to filter that out first and then pass that to the invoke code…

This is how we can convert OADate…