View Single Post
 
Old 03-14-2017, 08:20 PM
Mikayla Mikayla is offline Windows 10 Office 2013
Novice
 
Join Date: Mar 2017
Posts: 1
Mikayla is on a distinguished road
Default Running total automated

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
Reply With Quote