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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!