#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stop the date from changing | ep2002 | Word | 18 | 11-30-2023 05:28 AM |
Stop Automatic Date-Update | janetb | Word | 10 | 11-10-2016 12:05 AM |
Calculating age of something from a Date Picker | BoringDavid | Word VBA | 12 | 01-13-2014 02:40 AM |
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 |