How to calculate using a 7 day workweek (to replace NETWORKDAY)?


I am using this formula to calculate the # of days it takes to get to a particular task called, Enable. Range 2 = %Complete and Range 1 = Start Date of Enable. It calculates correctly using 5 days per week. I am now being asked to count using 7 days per week. Is there a comparable function that I can swap out for NETWORKDAY? I haven't found anything that works.

I have Gantt working days set to Sun - Sat.

Best Answer

  • bisaacs
    bisaacs ✭✭✭✭✭
    Answer ✓

    Hey @Kathy PPT,

    You should just be able to use NETDAYS(), as that counts every day between two dates.

    Hope this helps!

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!