Based on a closed date and a remaining budget can I figure what the monthly spend should be
I want to be able to caluculate based on the contract closed date of a project / remaining budget what will the monthly spend be?
Best Answer

This depends on a lot of factors of how you want the breakdown to happen, but off the top of my head here is what I'm thinking.
I think you'll probably want to calculate how many months there are between now and the close date, and then divide the remaining budget of that number of months.
To do that you'll need to use the TODAY() function to return the current date and use the MONTH() function to pull the current month out of the date (may also need to pull the year out as well). Then you'll want to do the calculation to subtract the number of months left from TODAY() to the close date, then divide you remaining budget by that number.
Does that make sense?
Answers

This depends on a lot of factors of how you want the breakdown to happen, but off the top of my head here is what I'm thinking.
I think you'll probably want to calculate how many months there are between now and the close date, and then divide the remaining budget of that number of months.
To do that you'll need to use the TODAY() function to return the current date and use the MONTH() function to pull the current month out of the date (may also need to pull the year out as well). Then you'll want to do the calculation to subtract the number of months left from TODAY() to the close date, then divide you remaining budget by that number.
Does that make sense?

Thank you, I will give it a try!
Help Article Resources
Categories
Check out the Formula Handbook template!