How to add 5days to date available in excel

[rsr.chandu]

PFA

I have a column shipdate i am using FOR each DATA TABLE to fetch that row

i want to add 5 days to shipdate value
(Eg: Shipdate value: 11/21/2022+5 days =11/26/22)

I tried but it is not working

Can anyone suggest How to add 5 days to shipdate

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@rsr.chandu

days to shipdate valu

Hi @rsr.chandu
Try the below code

Datetime.ParseExact(CurrentRow(“ShipDate”).ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture).AddDays(5).ToString

[Rahul_Unnikrishnan]

Hello @rsr.chandu

You can use modify Date Activity to meet this requirement or you can use the expression .

How to Modify Date in UiPath? Modify Date activity explained with demo

Thanks

[raja_ias (PALANIRAJA PARAMAN)]

Convert.ToDatetime(Currentrow(“ColumnName”).tostring).AddDays(5).tostring("MM/dd/yyyy)

[kennbalobalo (Kenneth Balobalo)]

AddDays.zip (10.1 KB)
Hi @rsr.chandu,

In your For Each Row in DataTable activity, add an Assign activity to pass on the adding with the syntax:

Convert.ToDatetime(Currentrow(“Ship Date”).ToString).AddDays(5).ToString(“MM/dd/yyyy”)

I have also attached a copy of the code for your reference. Thanks.

Kind regards,
Kenneth