Hi,
I have a column of Date data as shown in the excel below. I need to create a new column and minus 7 days in each date.
Thanks for helping!
New Microsoft Excel Worksheet.xlsx (8.4 KB)
Hi,
I have a column of Date data as shown in the excel below. I need to create a new column and minus 7 days in each date.
Thanks for helping!
New Microsoft Excel Worksheet.xlsx (8.4 KB)
-Use Excel scope application
-Use Read Range Activity
-Use Add data Column Activity
-Use For Each Row in Data Table
Hope it will help you
Regards
Gokul
Please refer the function below
DateTime.ParseExact(CurrentRow(0).ToString,“dd-MM-yyyy”,Globalization.CultureInfo.InvariantCulture).AddDays(-7).ToString(“dd-MM-yyyy”)
Refer the Xaml below
Main.xaml (18.8 KB)
Regards