ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   PLEASE HELP URGENT (https://www.excelbanter.com/excel-worksheet-functions/162641-please-help-urgent.html)

Frontier

PLEASE HELP URGENT
 
I need to be able to predict a date of completion through a percent completed
over a year, please, please help!!!

JE McGimpsey

PLEASE HELP URGENT
 
Is your prediction based on linear progress (i.e., if you're halfway
done, it will take twice the total elapsed time)? or some other function?

A linear solution:

A1: <start date
A2: <% completed
A3: =A1 + (TODAY()-A1)/A2

In article ,
Frontier wrote:

I need to be able to predict a date of completion through a percent completed
over a year, please, please help!!!



All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com