calculated field

[assaf1978]

Hi,
How can I calculate the duration between the task's finish date and today?
Only including the working days.
I've tried [finish]-date() but it uses the entire week and not only working
days.

Thanks,
Assaf

 

[Rod Gill]

Try the Date/Time function ProjDateSub. It lets you specify a calendar which
the function uses to evaluate which days are working and which non-working.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Dytham]

Or even, for what you seem to be trying to do, the function ProjDateDiff.

Try the Date/Time function ProjDateSub. It lets you specify a calendar which
the function uses to evaluate which days are working and which non-working.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi,
How can I calculate the duration between the task's finish date and today?
Only including the working days.
I've tried [finish]-date() but it uses the entire week and not only
working
days.

Thanks,
Assaf

 

[assaf1978]

Thank you! Thank you! Thank you!

Or even, for what you seem to be trying to do, the function ProjDateDiff.

Try the Date/Time function ProjDateSub. It lets you specify a calendar which
the function uses to evaluate which days are working and which non-working.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi,
How can I calculate the duration between the task's finish date and today?
Only including the working days.
I've tried [finish]-date() but it uses the entire week and not only
working
days.

Thanks,
Assaf