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.

Find more posts tagged with

Templates

Formulas

Project Management

Media & Entertainment

Comments

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.

Screen Shot 2018-04-24 at 3.20.43 PM.png

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

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.