Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-28-2021, 01:52 PM
Dwebby Dwebby is offline Stop calculating by inputting an end date. Windows 10 Stop calculating by inputting an end date. Office 2010
Novice
Stop calculating by inputting an end date.
 
Join Date: Nov 2021
Posts: 1
Dwebby is on a distinguished road
Default Stop calculating by inputting an end date.

Can anyone help please .
I've set up a spreadsheet to track an account. I have a start date for the account, then the daily cost, total days the account has been open(using the today function)and total cost to date.
Now what I am needing is an end date column with a formula that will stop calculating the total cost the date the account is closed.
Excel isn't my strength and I've been scratching my head for a few days trying to figure it out. All help extremely appreciated.
Reply With Quote
  #2  
Old 11-29-2021, 12:33 AM
ArviLaanemets ArviLaanemets is offline Stop calculating by inputting an end date. Windows 8 Stop calculating by inputting an end date. Office 2016
Expert
 
Join Date: May 2017
Posts: 656
ArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of light
Default

You need a table with columns like
Account, StartDate, EndDate, DailyCost, DaysTotal, CostTotal

The formulas for DaysTotal and CostTotal will be (I used Table syntax for formulas, replace Table field references with regular ones in case you prefer this)
Code:
=(MIN(TODAY(),[@EndDate])-[@StartDate]) ' This is the formula for DaysTotal
=[@DailyCost]*[@DaysTotal] ' This is the formula for CostTotal
Reply With Quote
  #3  
Old 11-29-2021, 08:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Stop calculating by inputting an end date. Windows 7 64bit Stop calculating by inputting an end date. Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,526
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Or post a sample sheet (no pics please)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop calculating by inputting an end date. Stop Automatic Date-Update janetb Word 10 11-10-2016 12:05 AM
Stop calculating by inputting an end date. Stop the date from changing ep2002 Word 16 04-07-2015 10:54 AM
Stop calculating by inputting an end date. Calculating age of something from a Date Picker BoringDavid Word VBA 12 01-13-2014 02:40 AM
Stop calculating by inputting an end date. Calculating age at date jamierbooth Excel 2 02-22-2011 03:35 AM
Cannot stop the date being printed in the footer Ubtree Outlook 0 10-13-2007 11:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:24 AM.


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