Using dates in formulas

G

Garfield

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.
 
A

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.

Garfield said:
How do I use dates in formulas? For example, I want to figure out how
Click to expand...
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.
 
Top