TIME ELAPSED VS GOAL

avixion
StarLounger
Posts: 85
Joined: 15 Apr 2017, 17:59

TIME ELAPSED VS GOAL

Post by avixion »

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

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: TIME ELAPSED VS GOAL

Post by HansV »

Here are some way of looking at it:

S0286.png

And these are the formulas I used:

S0287.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

avixion
StarLounger
Posts: 85
Joined: 15 Apr 2017, 17:59

Re: TIME ELAPSED VS GOAL

Post by avixion »

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

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: TIME ELAPSED VS GOAL

Post by HansV »

In B4 (the current date), enter the formula =TODAY()
The results will then be updated automatically each day.
Best wishes,
Hans

avixion
StarLounger
Posts: 85
Joined: 15 Apr 2017, 17:59

Re: TIME ELAPSED VS GOAL

Post by avixion »

Thank you HansV, much appreciated!

Regards,
Avixion