Need to calculate estimated end date based on rate of spend

[DamianK]

I apologize if I missed threads that discuss this, but I'm trying to calculate the estimated end/depletion date of available money based on current rate of spend.

Here's the scenario (per example screenshot):

Column C has a list of PO's.
Column D-O shows amount of money spent against each PO in a given month (again, just an example)
Column P shows the remaining amount of each PO.
Column Q is what I'm trying to figure out.

I need to figure out the formula that calculates the estimated date Column P for each PO will reach zero.

Any help would be much appreciated!

 

[awoohaw]

Okay, I did not have that data so I needed to calculate it from the PO amount and the monthly payments. If you have another source for that column, that is okay. Actually, it is probably a good check to make sure your calculations balance out.
Regardless, the amount (however it is calculated) in column P is used by the calculation in column Q.. and as long as it works regardless of the source of the value in P you are good to go.

 

[DamianK]

Okay, I did not have that data so I needed to calculate it from the PO amount and the monthly payments. If you have another source for that column, that is okay. Actually, it is probably a good check to make sure your calculations balance out.
Regardless, the amount (however it is calculated) in column P is used by the calculation in column Q.. and as long as it works regardless of the source of the value in P you are good to go.

Awesome! I'll respond if I continue having issues.