Minus Days in Date Column

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 @Yudhisteer_Chintaram1

This can be done as follows

image

Attachment

Date minus 7.xaml (5.8 KB)

Hi @Yudhisteer_Chintaram1

-Use Excel scope application
-Use Read Range Activity
-Use Add data Column Activity
-Use For Each Row in Data Table

  • Use Assign activity
    Create Variable = CDate (row(“Date”).Tostring).AddDays(-7).Tostring

Hope it will help you

Regards
Gokul

Hi @Yudhisteer_Chintaram1

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