Is it possible to automate in Numbers?

Not sure if the hive mind of MPU is the place to ask this, or whether there is a more specific Numbers forum, or even whether it would be a question for Automators.

What I would like is to have a Numbers sheet to track money owed.
Example: Date 1 sum owing $10000 Annual interest 5%

I would like to be able to open the sheet on Date 2 and the sum owing automatically calculate

Ie sum owing is ($10000 + ((Date 2 - Date 1)*(0.05/365)

Is this possible?

Thanks in advance

For date1 of 20 August, this is the formula you’d use:


Wow thanks @dfay! Will give that a shot