Duration Formula Workdays Only

Madeleine Eames

Hello. What formula would you use to calculate the duration (number of days) of a task from Start Date to End Date that only counts workdays?

I realize that most templates come with this column built in, but I am creating a second column so I can compare planned duration to actual duration.

Thank you for your help!

Madeleine Eames

Thank you!!

Mary_A

@Madeleine Eames This calcs that for me in my sheet.

=NETWORKDAYS([Due Date]$1, [Date Completed]$1)

I'm calculating in a single row, if you want to do this down a column, this works too:

=NETWORKDAYS([Due Date]@row, [Date Completed]@row)

Madeleine Eames

Thank you!!