Date Complete Date Created Total Days to Install
2/27/2017 2/17/2017 10
2/27/2017 2/22/2017 5
2/27/2017 2/21/2017 6
2/27/2017 2/14/2017 13
2/27/2017 2/17/2017 10
2/27/2017 2/20/2017 7


So this is the data I am working with. Currently I am using this formula to get the Total days to install figure, =DATEDIF(K14,J14,"d"). This gives me the total days in between the dates, where I am trying to just get the work/business days.

Then I am taking the total days to install data and getting the average between a range of dates, a normal work week, using this formula =AVERAGE(IF(ISNUMBER(P1:P2),P1:P2))