![]() |
#1
|
|||
|
|||
![]() 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 |
#2
|
|||
|
|||
![]()
If you are always taking away the same quantity, then it's fairly easy.
End_qty=Start_qty-Deduct_qty*(Today()-Start_date) |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
HelicopterChick | Excel | 3 | 08-23-2016 04:52 AM |
![]() |
Chancy | Excel | 3 | 03-02-2015 01:20 PM |
Automated E Mailing | gobby | Outlook | 2 | 05-21-2014 12:23 AM |
Automated Analyzer | NewPuppy | Excel | 20 | 01-09-2014 01:38 PM |
Running total in Excel chart | jen152638 | Excel | 0 | 06-14-2010 05:38 AM |