Current Date - GIVEN DATE (How Many Days InBetween them)

[Krishan_Rapswal]

Book1.xlsx (8.8 KB)

find days between today and given date
In New Column ( Number Of Days )

[ppr (Peter)]

[michael.zura (GuardiansFan)]

@Krishan_Rapswal

How to find total Number of days from given date taken from excel file and comparing to current date Excluding Saturday and Sunday

Please help me i tried all option available in uipath forum here my excel filedata1.xls (24.5 KB)

Regards

[Sudharsan_Ka]

hi @Krishan_Rapswal

while looping through all rows use this expression to get the diff
Checkout this expression

Datediff(DateInterval.Day,Cdate(CurrentRow("Date").ToString),now)

or

Datediff(DateInterval.Day,DateTime.ParseExact(CurrentRow("Date").ToString,{"dd.MM.yyyy hh:mm:ss","MM/dd/yyyy hh:mm:ss","MM-dd-yyyy","dd-MM-yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None),now)

Regards
Sudharsan

[Krishan_Rapswal]

i didn’t understand this can you please elaborate

[Krishan_Rapswal]

there are 2 date in the excel
1/31/2023 & 1/23/2023

[Gokul_Jayakumar (Gokul Jai)]

Hello @Krishan_Rapswal
Refer to this Xaml file you may get some idea
DateInterval.zip (146.3 KB)

[Krishan_Rapswal]

how to find due date in this less than 20 MEANS NO DUE
or Equal DUE
or greater than 20 DUE

[Gokul_Jayakumar (Gokul Jai)]

@Krishan_Rapswal
For Example, create the Status column in F in excel
Add the if condition below to the Assign activity in Loop
If Condition is Cint(CurrentRow(4).ToString)>=20
Then assign CurrentRow(5)="Due"
Else assign CurrentRow(5)="No Due"