How to convert date format from dd-mm-yyyy to MM-dd-yyyy in excel

[supermanPunch (Arpan)]

Hi @sathish_Kumar6 ,

Could you check the below Post, it does address the same issue, you could just use the format that is required for your case :

DateTime.ParseExact the whole Column without looping

Hi @arthurang , If the Target Goal for you is to represent the dates in Excel Sheet Column in MM/dd/yyyy format, maybe you could use the Format Cells Activity if you have the latest versions in place. [image] You would require to know which column the Date column is present (A or B or C, in my case it is J), then we can use the Range as J:J. If we do not know the position of the column in the Excel sheet too, we can dynamically be able to find it as well. Input : [image] Output: [image] …