Hi folks - I am somewhat saavy, but formulas are rather new to me. I
supervise a homeless shelter which charges $7/night. I am trying to
"modernize" it with a spreadsheet for fees.

I need a way to calculate based on "today's date" minus "entry date" (which
I have done with a successful calculation.)

I also have a column in the formula which adds payments made against the
total due (based on the current date and the entry date above.)

Question: How can I do this showing the date of each payment made (as
opposed to just manually adding the dollar amount of each payment to a
running total.)

Example: If client A pays $7.00 on Monday and $21.00 on Tuesday (paying
ahead), how can I "date" each of these payments?

Is this something achievable in Excel?

Thx in advance to all who reply. Also if someone has a better way to do
this type of function(s), please: I'm all ears.

Regards,
Marshall