Skip to content
ProjectControls.com
Microsoft Project

Calculating % on track

In the Open Standard
Jeff ZMember for 18 years 5 months
Created
2
2
0
I am trying to display graphical indicators on each task for whether they are on schedule based on today’s date subtracted from duration remaining compared against % complete. I have everything in place, except that the formula (finish - today) gives total calendar days remaining, and I am looking for total work days remaining, based on the project calendar and/or the resources calendar, which includes holidays and vacation.

Any ideas?

TIA (thanks in advance),

Jeff
Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Niek Zonneveld ·
    #1
    Jeff,

    The standard function: "ProjDateDiff( date1, date2, calendar )" is what you are looking for.

    This will give you the working days (expressed in minutes in from the top of my head) between the two dates, according to the specified task calendar. (not the resource calendar)

    H.T.H.

    Niek.
    Report
  2. 0
    Jeff Z ·
    #2
    Awesome. Thank you!
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?