![]() |
|
#1
|
|||
|
|||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ep2002 | Word | 18 | 11-30-2023 05:28 AM |
![]() |
janetb | Word | 10 | 11-10-2016 12:05 AM |
![]() |
BoringDavid | Word VBA | 12 | 01-13-2014 02:40 AM |
![]() |
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 |