Do You have a workbook?
Pl Check screenshot and the attached.
I Took Average Sales and Distributed it across months to Emulate your Situation.
If It Helps, Pl mark It Helpful and CORRECT To Close Thread
Monthly Distribution.twbx 1.2 MB
Thanks for the help but not quite what I'm looking for. This shows the average cost spread across months but what I need is the actual cost. So going back to my hypothetical example of a specific contract that lasts 6 months (Jan '18 through June '18) with an average monthly contract value of $10k: once contract ends in July '18, then assuming all other contracts remaining unchanged, the total Contract Value should decrease by $10k since that contract expired at the end of June. Am I making sense?