Days Difference Between Date

[FMHasan]

I have attached an excel sheet. I need to find out how much time we are taking for payment against each of individual purchase. Like in this data sheet 1st purchase done at 06/01/2021 & Amount was 30,94,110 & payment date was 28/02/2021 & the amount was exactly same. Difference between purchase to payment days were(28/02/2021 - 06/01/2021) = 53 days . But the main problem is we always don't payment exact purchase amount at one time. We made it through 2 or more partial payment in several days. So, I need a result of days difference between Purchase & payment days. Here one important things need to clear, in time of finding the result each individual purchase amount must be Zero (0) by payment. And the last date of payment (When Purchase =< Payment ) then the result will be computing by considering purchase date to last date of payment. Result will be shown in beside of Purchase column- (column E). Is there any formula or VBA code can solve this problem? Thanks in advance for your supporting Mama Bagne.xlsx A B C D 1 Date Transaction Payment Purchase 2 06/01/2021 Purchase 30,94,110 3 30/01/2021 Purchase 30,70,234 4 08/02/2021 Purchase 30,77,656 5 28/02/2021 Trust Bank Ltd-7017-0212003738(C/A) 30,94,110 6 02/03/2021 Purchase 29,60,141 7 13/03/2021 Purchase 26,75,790 8 06/04/2021 Purchase 31,71,930 9 08/04/2021 Trust Bank Ltd-7017-0212003738(C/A) 15,00,000 10 15/04/2021 Trust Bank Ltd-7017-0212003738(C/A) 15,00,000 11 22/04/2021 Trust Bank Ltd-7017-0212003738(C/A) 15,00,000 12 02/05/2021 Purchase 33,95,860 13 04/05/2021 Purchase 30,52,800 14 05/05/2021 Trust Bank Ltd-7017-0212003738(C/A) 13,75,790 15 08/05/2021 Trust Bank Ltd-7017-0212003738(C/A) 15,00,000 16 09/05/2021 Purchase 33,99,560 17 11/05/2021 Purchase 50,89,276 18 13/05/2021 Trust Bank Ltd-7017-0212003738(C/A) 15,00,000 19 20/05/2021 Purchase 45,31,760 20 25/05/2021 Trust Bank Ltd-7017-0212003738(C/A) 15,05,431 21 31/05/2021 Trust Bank Ltd-7017-0212003738(C/A) 14,00,000 22 09/06/2021 Purchase 16,96,820 23 15/06/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,00,000 24 21/06/2021 Purchase 16,99,532 25 24/06/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,00,000 26 05/07/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,00,000 27 11/07/2021 Purchase 16,69,510 28 15/07/2021 Trust Bank Ltd-7017-0212003738(C/A) 17,67,790 29 27/07/2021 Trust Bank Ltd-7017-0212003738(C/A) 15,00,000 30 04/08/2021 Purchase 16,81,920 31 08/08/2021 Purchase 16,77,540 32 12/08/2021 Trust Bank Ltd-7017-0212003738(C/A) 15,52,800 33 22/08/2021 Purchase 16,71,700 34 24/08/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,50,000 35 02/09/2021 Purchase 16,73,160 36 09/09/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,50,000 37 16/09/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,50,000 38 23/09/2021 Trust Bank Ltd-7017-0212003738(C/A) 17,00,000 39 23/09/2021 Purchase 16,74,620 40 30/09/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,50,000 41 02/10/2021 Purchase 16,76,810 42 05/10/2021 Purchase 11,39,092 43 10/10/2021 Trust Bank Ltd-7017-0212003738(C/A) 17,00,000 44 18/10/2021 Trust Bank Ltd-7017-0212003738(C/A) 20,00,000 45 20/10/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,00,000 46 24/10/2021 Purchase 19,21,335 47 27/10/2021 Purchase 19,21,335 48 28/10/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,00,000 49 28/10/2021 Purchase 18,87,935 50 28/10/2021 Purchase 19,23,840 51 07/11/2021 Purchase 19,17,160 52 11/11/2021 Trust Bank Ltd-7017-0212003738(C/A) 16,00,000 53 13/11/2021 Purchase 19,23,005 54 15/11/2021 Purchase 19,23,840 55 16/11/2021 Trust Bank Ltd-7017-0212003738(C/A) 10,00,000 56 21/11/2021 Trust Bank Ltd-7017-0212003738(C/A) 10,00,000 57 23/11/2021 Trust Bank Ltd-7017-0212003738(C/A) 9,00,000 58 25/11/2021 Purchase 19,09,645 59 30/11/2021 Trust Bank Ltd-7017-0212003738(C/A) 10,68,378 60 12/12/2021 Trust Bank Ltd-7017-0212003738(C/A) 13,00,000 61 13/12/2021 Purchase 19,27,215 62 18/12/2021 Purchase 19,45,012 63 20/12/2021 Purchase 19,50,945 64 21/12/2021 Trust Bank Ltd-7017-0212003738(C/A) 13,00,000 65 30/12/2021 Trust Bank Ltd-7017-0212003738(C/A) 14,22,400 66 31/12/2021 Purchase 19,45,860 67 06/01/2022 Purchase 19,48,402 68 06/01/2022 Purchase 19,50,945 69 10/01/2022 Trust Bank Ltd-7017-0212003738(C/A) 15,00,000 70 21/01/2022 Trust Bank Ltd-7017-0212003738(C/A) 15,00,000 71 22/01/2022 Purchase 19,46,707 72 22/01/2022 Purchase 19,49,250 73 25/01/2022 Trust Bank Ltd-7017-0212003738(C/A) 20,00,000 74 31/01/2022 Trust Bank Ltd-7017-0212003738(C/A) 14,90,522 75 02/02/2022 Trust Bank Ltd-7017-0212003738(C/A) 20,00,000 76 02/02/2022 Cash Head Office 20,00,000 77 11/02/2022 Trust Bank Ltd-7017-0212003738(C/A) 18,00,000 78 18/02/2022 Trust Bank Ltd-7017-0212003738(C/A) 18,00,000 79 28/02/2022 Trust Bank Ltd-7017-0212003738(C/A) 20,54,445 80 10/03/2022 Trust Bank Ltd-7017-0212003738(C/A) 19,00,000 81 20/03/2022 Purchase 19,50,097 82 20/03/2022 Purchase 19,49,250 83 21/03/2022 Trust Bank Ltd-7017-0212003738(C/A) 19,00,000 84 31/03/2022 Trust Bank Ltd-7017-0212003738(C/A) 19,64,005 85 07/04/2022 Purchase 22,46,400 86 07/04/2022 Purchase 22,44,450 87 12/04/2022 Trust Bank Ltd-7017-0212003738(C/A) 25,00,000 88 20/04/2022 Trust Bank Ltd-7017-0212003738(C/A) 25,00,000 89 30/04/2022 Trust Bank Ltd-7017-0212003738(C/A) 25,00,000 90 14/05/2022 Trust Bank Ltd-7017-0212003738(C/A) 21,78,677 91 26/05/2022 Trust Bank Ltd-7017-0212003738(C/A) 16,50,000 Mama Vagne Oil Mill

 

[Kerryx]

You really need a way to link the purchase to the payment for example a PO ( Purchase Order) number as just linking a value or multiple values to a payment will lead to mismatching payments to purchases