# Check the date which is more than one time. if it is more that one time have to sum the debit amount of that dates

Hi All,
I have excel as below in that i have to check the date which is more than one time. if it is more that one time i have to sum the debit amount of that dates, please can any one help me regarding this.
Thanks And Regards,
Santhoshi
12.xlsx (9.5 KB)

@ryava_santhoshi What do you mean by â€śwhich is more than one time?â€ť

1. Create a new variable of type Decimal - weâ€™ll call it dec1
2. Open the excel and read the entire sheet and save to a datatable - weâ€™ll call dt1
3. For each row in dt1:
If CDate(row.item(â€śDateâ€ť).tostring) > YourDateTime
Assign dec1 = dec1 + cdec(row.item(â€śDebitâ€ť).Tostring)
End If
Next row

If you donâ€™t have the datetime saved already as YourDateTime, you can instead use the following:

If CDate(row.item(â€śDateâ€ť).ToString > (new datetime(2019,6,25)). Replace the digits inside with the year as a 4 digit integer, month as a 1 or 2 digit integer, and day as a 1 or 2 digit integer

@Kyle in the excel in date column if date is more than one time present then i have to find the sum of debit of those datesâ€¦sorry for late reply

please check this workflowâ€¦
test.zip (9.6 KB)

1 Like

The perfect solution @pathrudu thank you so much.

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