% of Schedule Calculation
 

Hi all!!

Unique problem here - at least I have not found the answer yet. I am certain
one of you can help.

I have the following 3 columns:
Report Date
Start
Finish

I would like to calculate % of schedule passed using these dates. In other
words, I would like to calculate what percentage of time has passed for a
particular activity on the 'Report Date'.

PLEASE HELP!!!!!!!!!
Mike

Do you mean that B2 contains the start date, something like Dec 15, 2004, C2
contains the date the work is to be completed, say Mar 1, 2005, and the
ReportDate in A2 is Jan 15, 2005?

If so

=(A2-B2)/(C2-B2)

and format as percent.

On Thu, 13 Jan 2005 17:12:29 -0500, "Mike Pandher"
wrote:

Hi all!!

Unique problem here - at least I have not found the answer yet. I am certain
one of you can help.

I have the following 3 columns:
Report Date
Start
Finish

I would like to calculate % of schedule passed using these dates. In other
words, I would like to calculate what percentage of time has passed for a
particular activity on the 'Report Date'.

PLEASE HELP!!!!!!!!!
Mike