Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2017, 08:20 PM
Mikayla Mikayla is offline Running total automated Windows 10 Running total automated Office 2013
Novice
Running total automated
 
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
  #2  
Old 03-15-2017, 06:19 AM
gebobs gebobs is offline Running total automated Windows 7 64bit Running total automated Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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

End_qty=Start_qty-Deduct_qty*(Today()-Start_date)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Running total automated 30 Day Running or Rolling total (Multiple Sheets/Workbooks) HelicopterChick Excel 3 08-23-2016 04:52 AM
Running total automated Running total possible in a pivot table? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft