Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Calculating % on track

2 replies [Last post]
Wed, 2008-04-23 13:43
Jeff Z
User offline. Last seen 16 years 16 weeks ago. Offline
Joined: 23 Apr 2008
Posts: 4
Groups: None
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
Top

Replies

Wed, 2008-04-23 17:19
#1
Jeff Z
User offline. Last seen 16 years 16 weeks ago. Offline
Joined: 23 Apr 2008
Posts: 4
Groups: None
Awesome. Thank you!
Top
Wed, 2008-04-23 14:49
#2
Niek Zonneveld
User offline. Last seen 2 years 18 weeks ago. Offline
Joined: 17 Mar 2005
Posts: 188
Groups: None
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.
Top