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

Book1.xlsx (8.8 KB)

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




hi @Krishan_Rapswal

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




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)


i didn’t understand this can you please elaborate

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

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

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

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"

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.