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

Kathy PPT

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.

bisaacs

Hey @Kathy PPT,

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

Hope this helps!

bisaacs

Hey @Kathy PPT,

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

Hope this helps!

Kathy PPT

@bisaacs,

Thank you, it worked. I knew it was something simple, just couldn't find it.