Running total automated

[Mikayla]

How can I create a spreadsheet that keeps a running total of something that is automatically updated each day when I open it?



Eg. I have 12 eggs on 13 March, but I want it to take away 2 eggs every day from the total, so when I open the spreadsheet on 14 March it will automatically tell me I have 10 eggs, and on 15 March 8 eggs etc - rather than me updating it every day myself subtracting 2 eggs.

Surely if it can count down to a date using the "today" function, it can do this?

Thanks

[gebobs]

If you are always taking away the same quantity, then it's fairly easy.

End_qty=Start_qty-Deduct_qty*(Today()-Start_date)