% of Schedule Calculation

  • Thread starter Thread starter Mike Pandher
  • Start date Start date
M

Mike Pandher

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
 
Not accounting for weekends and holidays:-

A1 = report_date
A2 = start_date)
A3 = finish_date

=(A1 - A2) / (A3 - A2)

formatted as percentage
 
Back
Top