Hi @Rohan Tiwari ,
Following the below options you can achieve your requirement.
i.e : =TEXT(E4, "DD/MM-YYYY").
You can achieve this using the Excel Basic and DateTime Actions.
First, drag in the Excel Open and Close Actions, and add a Loop: For Each Row Excel Basic in between the two Action Actions.
Add a Excel Basic: Go To Cell Action and go to the starting row of the cell where the dates column is present.
Ensure that the same session is provided to both the excel actions and also to the loop.
After that, drag in a DateTime: Assign Action and use the following format to convert the string to date ->
M/d/yy (this is how Excel usually stores dates, modify if the format is different)
Then we will convert it into the desired format using a DateTime: To String Action:
Then we set the value to the currently active cell and after which we will move onto the next cell address ->
Thank you Ashwin.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.