Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2021, 12:33 AM
ArviLaanemets ArviLaanemets is offline Stop calculating by inputting an end date. Windows 8 Stop calculating by inputting an end date. Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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
Reply



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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft