Based on a closed date and a remaining budget can I figure what the monthly spend should be

Lori Cross

I want to be able to caluculate based on the contract closed date of a project / remaining budget what will the monthly spend be?

David Tutwiler

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?

David Tutwiler

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?

Lori Cross

Thank you, I will give it a try!