Thread: Stop calculating by inputting an end date.
View Single Post
 
Old 11-29-2021, 12:33 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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