d=daily goal
t=total days
r=remaining days
m=Month to date average
g=End of month goal
I need the formula to get d.
Example numbers
t=17
r=5
m=19.25
g=17.25
What formula would I use to get the daily goal to reach the end of month goal.
EDIT: Basically, the goal is to reach a lower number, the end of month is an average for each day in the month and I need a formula to calculate what I want to reach each day to get that goal.
Bookmarks