calculate number of days taken to pay

[ayman galal]

how many days taken to pay full value for each item?

 

[AliGW]

Attach a sample workbook, please, not a screenshot.

 

[ayman galal]

kindly find the attached file

 

[Peter Bartholomew]

You would use running totals (accumulation) for both the sales and payments and look up the dates.

= LET(
    sale,      FILTER(sales, sales>0),
    salesDate, FILTER(date, sales>0),
    salesAcc,  SCAN(0, sale, SUM),
    pmntsAcc,  SCAN(0, payments, SUM),
    pmntDate,  XLOOKUP(salesAcc, pmntsAcc, date, "unpaid", 1),
    HSTACK(sale, pmntDate, pmntDate-salesDate)
  )

The resulting table is

If you want to show the payment days as part of the original table then output "" for lines without sales rather than filtering them out.

I have just added a Lambda function variant.

= PaymentDaysλ(sales, payments, date)