Microsoft Office Forums Stop calculating by inputting an end date.
 Register FAQ Search Today's Posts Mark Forums Read

#1
11-28-2021, 01:52 PM
 Dwebby Windows 10 Office 2010 Novice Join Date: Nov 2021 Posts: 1
Stop calculating by inputting an end date.

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.
#2
11-29-2021, 12:33 AM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 656

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```
#3
11-29-2021, 08:42 AM
 Pecoflyer Windows 7 64bit Office 2010 Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,526

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

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post janetb Word 10 11-10-2016 12:05 AM ep2002 Word 16 04-07-2015 10:54 AM BoringDavid Word VBA 12 01-13-2014 02:40 AM jamierbooth Excel 2 02-22-2011 03:35 AM 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.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top