Changing Column Type to Date Format

Help
9

Check this workflow, and excel attached ,

Main.xaml (11.5 KB)
Source Excel sheet.xlsx (8.7 KB)

You would need to loop though the rows which conatins date format , and use the parse exact to format the date as per its input.

Also check out the format of the cells where you are putting in the dates. If it still shows as number , maybe you might have explictly formatted them to be numbers ?? try to put the cells in general format and see if it works.

2 Likes