Rest of the Year Calculation
Gfunc wrote:
HI,
I am trying to make a cormula that calculates what someone would be on time
to achieve, based on their current number and then project what they would be
on time to hit based on how many months are left in the year.
For June, it being half way, the number is multiplied by 2, that one is
easy...
For some reason, I am having a hard time figuring out what the rest of the
calculations would be for each month.
Any ideas would be greatly appreciated
Actually, for June it would be divided by 6 (June is the 6th month) and
multiplied by 12. Hope that helps you get the rest of the way.
|