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.

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)

Or post a sample sheet (no pics please)

__________________
Using O365 v2503 - 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