Stop calculating by inputting an end date.

ArviLaanemets · #1 11-29-2021, 12:33 AM

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

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