Formula to compute costs based on months to only include months between the EndDate and GoLiveDate
I have a sheet to compute cost based on EndDate and GoLiveDate. If the StartDate is less than GoLiveDate then cost is sum of monthly cost between StartDate and GoLiveDate.
Test 3 | StartDate: 5/29/2022 | GoLiveDate: 9/7/2022, Cost: May cost + June cost + July cost + August cost + September cost.
Test 4 | StartDate: 6/19/2022 | GoLiveDate: 10/21/2022, Cost: June cost + July cost + August cost + September cost + October cost
Currently I have the formula: =(IF(EndDate@row < GoLiveDate@row, SUM(March@row:June@row), 0)). However, I have to manually change the SUM formula to capture the specific months.
How can I automate this. Please find attached screenshot of my test sheet for reference.
Thank you! Appreciate all the help!
Help Article Resources
Check out the Formula Handbook template!