Duration formula

jeckenrode42196

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.

Chris McKay

Hi there,

Is this what you're looking for?

=NETWORKDAY([Actual Start Date]1, [Actual Finish Date]1)

Kind regards,

Chris McKay

jeckenrode42196

Thanks Chris but that formula doesn't work.  Here's a screenshot.

jeckenrode42196

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.

Emmanuel Ajayi

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

Catherine Pauciello

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?

Kelly Moore

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