Hello there,
I am looking for a formula to calculate goal vs actual in a certain time.
For example:
If goal is 1000 that needs to be completed in 12 months (from 01/01/2021 - 12/31/2021).
The actual progress as of today April 11, 2021 is 78.
What I need to calculate (in percentage) is where we are as of April 11, 2021 vs where we should be?
Thanks for all you help.
Avixion
TIME ELAPSED VS GOAL
-
- Administrator
- Posts: 78487
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: TIME ELAPSED VS GOAL
Here are some way of looking at it:
And these are the formulas I used:
And these are the formulas I used:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 85
- Joined: 15 Apr 2017, 17:59
Re: TIME ELAPSED VS GOAL
Thank you so much HanV, everything works great in this formula and it is exactly what I was looking for except the "expected percentage" which should be updating with date every day. e.g. as of today 04/13/2021 if I should be at 28% it should automatically increase a little bit for tomorrow as time passes regardless of actual progress.
Regards,
Avixion
Regards,
Avixion
-
- Administrator
- Posts: 78487
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: TIME ELAPSED VS GOAL
In B4 (the current date), enter the formula =TODAY()
The results will then be updated automatically each day.
The results will then be updated automatically each day.
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 85
- Joined: 15 Apr 2017, 17:59
Re: TIME ELAPSED VS GOAL
Thank you HansV, much appreciated!
Regards,
Avixion
Regards,
Avixion