% of Schedule Calculation

[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

 

[Ken Wright]

Not accounting for weekends and holidays:-

A1 = report_date
A2 = start_date)
A3 = finish_date

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

formatted as percentage