I am attempting to write a formula to track the days since our department received a request and have it take into consideration if the request has been completed in another column.

Currently I have one column tracking the days since requested (using TODAY function) and have conditional formating to highlight when we are over our SLA (service level agreement). However, this column does not take into consideration whether there is a completion date within the row so I created a second row to calculate the request completion turn around time. I would like either one formula to take all three dates into consideration, or a formula to accept the completed date calculation as final. My current fomulas are:

Request Tracking =IF(COUNT(D2,$U$2)<2,0,NETWORKDAYS(D2,$U$2)) where $U$2=TODAY
Completion Tracking =IF(COUNT(D2,R2)<2,0,NETWORKDAYS(D2,R2))

I'd prefer one column versus two to keep the spreadsheet size low.

Thanks!