Duration formula

jeckenrode42196 ✭✭✭
edited 12/09/19 in Formulas and Functions

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
    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)




  • Catherine Pauciello
    edited 01/05/21

    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
    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!