Completion at Year End Formula

[shornbuckle]

Hi - I need a formula that will show me a projection's percentage complete at year end. Every formula I find only shows completion through today.

 

[shornbuckle]

Well I wasn't expecting it to be this complicated until I plugged in the initial formula and these issues appeared. Thanks for your help.

 

[Joe4]

You are welcome. Glad we were able to help!

We see that you are new here, so we are just trying to give you some tips on how to get the best help as fast as possible.
Visual aids are usually extremely helpful, as they show us what your data looks like, how it is structured on your sheet, etc. (you know the old saying, "a picture says a thousand words!").

When presenting the examples and expected results, it is usually helpful to try to think and present all different scenarios you can think of. Many times people get in trouble when they try to "oversimplify" things, and then they get replies that answer the exact question that they posted here, but does not work for them in reality because their situation is more complex than the simple example. So I usually tell people not to oversimplify things for our sake. Try to post your question as it really pertains to you in your environment.

Good luck and happy excel-ling!