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...
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)?