Trying to calculate currently owed amount

Screenshot 2023-02-10 at 1.12.46 am.png

I have this document and what I need to do is have a cell in either E or F that tells me the current amount owing for todays date.

Row A = Amount Outstanding
Row B = Weekly Repayment Amount
Row C = A - B = C (Outstanding Amount)
Row D = Day Money Is Paid

How do I do this?

So, basically looking for today's date (or nearest date in the past?) in column D, and returning the corresponding value from column C?

If so, try this:

=LOOKUP(TODAY(),D:D,C:C)

When using the above code it returns a date not the amount?

That's odd. Attach a workbook of the sample that you shared in post #1, instead of a picture.

I can then put the formula directly into the workbook and show you what the formula does directly in said workbook.

Follow the yellow banner at the top of your screen for instructions on how to attach a sample workbook.

Try formatting the cell to General.

Originally Posted by josephteh

Try formatting the cell to General.

Thanks this fixed it