Completion Date vs. Due Date based on Associate

Hello -

I am trying to count the work days in between a due date vs. completion date by reviewer (not including weekends and holidays). Is this possible?

To compare the due date column date to the completion date and then count the work days in between those two dates for specific reviewers?

Right now I added a "work days between" column and calculated the days in between the due date and the completed date column using =[Due Date]528 - [Completed Date]528. Is there a way to not count weekends/holidays in the work days in this calculation?

I then calculate the work days between using the formula below

=SUMIFS([Work Days Between]:[Work Days Between], Reviewer:Reviewer, "Name") / COUNTIF(Reviewer:Reviewer, "Name")


Thank you in advance!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!