Here is what I have:
A B C D
Date Received Approved Date Denied Date Turn Time
1/1/14 1/13/14 9
Turntime is calculated with this formula:
=IF(A4<>"",IF(COUNT(B3,C3),NETWORKDAYS(A3,IF(B3<>"",B3,C3)),""),"")
What I need is to not count the first day it is received in the calculation for the Turn Time.
So in this instance I need the Turn Time to say 8 instead of 9.
If I just subtract a 1 then I get an error if the Approved Date or the Denied Date are not filled in yet.
Any help is appreciated.
Bookmarks