Using dates in formulas

[Guest]

How do I use dates in formulas? For example, I want to figure out how much interest a tenant has earned on their security deposit since they have lived here until now. I also want it to update itself daily according to the current day.

 

[Andy B]

Garfield

As long as your dates are Excel dates (recognised as dates by Excel) it is
just a case of using standard arithmatic.

If your first date is in A2 you can use =TODAY()-A2 to give the number of
days, months and/or years between the dates, by formatting the cell
accordingly.

HTH
Andy.

How do I use dates in formulas? For example, I want to figure out how

much interest a tenant has earned on their security deposit since they have
lived here until now. I also want it to update itself daily according to
the current day.