Formula that will consider 3 dates: requested , competed & TODAY and ignore if blank

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!

I have progressed slightly since my post. I have condensed the formula to one column:

=IF(P2="",NETWORKDAYS(B2,$S$2),NETWORKDAYS(B2,P2))

However, I cannot get it to ignore if P2(completed) AND B2(received) are blank. I am getting 29677 as a value if the are.

Any suggestions?

SOLVED!

=IF(B2<>"",IF(P2="",NETWORKDAYS(B2,$S$2),NETWORKDAYS(B2,P2)),0)

In the last portion when I had the cell populate it with a "" instead of 0 (as shown in formulat) my conditional formatting was not working correctly. The formatting considers a blank as filling my rule for any value over 20 is over SLA. Assuming it is considering the formula itself as a value over 20 I had it populate the cell with a 0 instead of blank and then I set conditional formatting to populate all 0 values as white text on white background so that it appears blank, since there isn't really a reason to track 0 SLA

For now at least. I still think there is a better way and would appreciate any suggestions.