Is it possible to automate in Numbers?

1

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

2

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

10000+((NOW()−DATE(2018,8,20))×0.05÷365)

3

Wow thanks @dfay! Will give that a shot