Forum Discussion
Remaining balances and averages
Hi everyone,
I need help please. I have a total production amount needed for the month, after each daily production, we need to know what our daily average for the remainder of the month would be for us to reach our aggregate monthly goal. (please see attached sheet). If anyone could please, please help with either of the highlighted areas on this sheet, that would be greatly, greatly appreciated! I only made this for 10 days, but the end product when completed will be for an entire month. Thank you so much for any help!!
Respectfully,
John
In C16:
=C15-$N$5
Using $N$5 enables us to fill the formula to the right.
In C17:
=N3-C15
In D17:
=C17-D15
In C18:
=IFERROR(C17/(EOMONTH(C13,0)-C13), "End of Month")
Hi Hans,
Thank you so much, worked great!! I feel so dumb, I honestly forgot about the $ value. But, if I could ask one more, how would the formula look like in C18 if I wanted to this weekly?
Thank you again so much for your help!
Respectfully,
John H
Do weeks run from Sunday to Saturday or from Monday to Sunday (or something else)?
