I have a variation of my most recently solved last post.
Capturing the number of days in cell T4 where there are two dates (Date Received in cell Q4 and Date Completed in cell S4), and leaving cell T4 blank when cell Q4 or cell S4 are blank or contain a non-date value.
Date Received (Q4) is 4/30/18 subtracted from Date Completed (S4) which is 5/15/18 gives you a difference of 12 days, when factoring in the weekend and holidays.
=IF(ISNUMBER(Q4),NETWORKDAYS(Q4,S4,HOLIDAYS!$A:$A),"")
Somewhere I need to add a reference to S4 I believe.
Bookmarks