The formula to calculate the date of repayment of debt

[SDCh]

Hi all,

I need formula or vb macro for this (anything that anyone can provide I appreciate it).

I want to calculate the date of repayment of debt (sales),
the excel sheet is attached for reference and for better understanding what i want.


Thanks in advance.

Regards,
SDCh.

[:) Sixthsense :)]

I am unable to understand your expected outcome

[SDCh]

This calculation actually need FIFO method,
but what I want are calculate the date between Sales and Payment
if the value of Sales - (total) value of Payment are even (or (total) value of payment > value of sales) then date of Sales - date of Payment.

Sorry if my explanation not good

[:) Sixthsense :)]

Thanks for the brief, it will be very much helpful if you show the expected output (i.e. Expected Date's).

[SDCh]

Column "Time Pay" on my example are my expected output that what i want.
And as you see on that column has a formula but I need "a better formula" or vb macro to fill that column
because with that I must do it one by one (manual).