Duration formula
I am using one of the PM templates while adding in additional columns for actual start dates and actual finish dates. As such, somewhere I have lost the duration formula in that column. Can someone please help me with the formula that would determine the work days for planned start and planned finish minus weekends? Thank you.
Comments
-
Hi there,
Is this what you're looking for?
=NETWORKDAY([Actual Start Date]1, [Actual Finish Date]1)
Kind regards,
Chris McKay
-
Thanks Chris but that formula doesn't work. Here's a screenshot.
-
Hi Chris - I'm sorry to trouble you. The formula you provided does not work. Can you help me to understand what I'm doing wrong? Thank you.
-
Hi Jecken,
This may sound silly but have you reworked the formula for your own personal column names.
As the formula provided by Chris has no errors.
I have done this for you based on the screenshot you provided.
=NETWORKDAY([Planned Start]1, [Planned Finish]1)
Regards,
Emmanuel
-
I'm replying to an old thread as I'm having the same issues. I want to do the projected dates (beginning, end) Duration, but also the actual and the formula is not work. Here is a screenshot. Can anyone help?
-
Hi Catherine
Your screenshot shows a missing bracket closing your first date and it appears there are spaces in the column name but not in the formula reference. Notice how the column names in the formula aren't colored? They will be when all the column references are correct.
If your error message isn't Unparseable, verify that the date columns are formatted as Date columns
Unless you need to specifically reference row 1, consider making your formulas even more robust by replacing the specific row numbers with @cell. =NETWORKDAY([Actual Start Date]@row, [Actual End Date]@row)
If this doesn't clear up your error, post back with more details
Kelly
Help Article Resources
Categories
Check out the Formula Handbook template!
