Working out dates between invoice date and payment date

Hi everyone

I am in the processes of creating a report, I have to work out the time between the invoice date and the payment date, I am able to do this when the invoice and payment is in the same week, but having issues when it is across weeks. I have enclosed the summary page and the data that is making up the report. Is there any way of doing this, as the current system run off a running total, so the creditors total will come back to nil during the year. Thanks in advance

Ali

Thanks for that, I don't quite understand how the "Lookup(2,1" works

It works really well once I do a little bit more tidy up of the data but does not work when there are 2 or more invoices included in the payment run.

I have attached a little bit more data into the file

Ali

Thanks for your help, I am currently working with 30,000 lines of data and working through the problems as I find them. Yes still need some help as your suggestion has solved 90% of the problem.

Stay safe.
Nikki

In the second file that is attached (the data that is highlighted in yellow), as there is more than one invoice from the supplies, I would like to be able to pick up the the easiest date of the invoice being the 7/1/21 and work the number of days from the payment being the 11/2/21. which is 35 days. A supplies may also have more that 2 invoices as well. Thanks in advance for your help.

Ali

Did you get a chance to look at this, or is it impossible to do?
Regards
Nikki

Ali

Thanks for your help Have a great day.

Nikki