How do I count how many business days from a date to today

[rentonhighlands]

I want to count how many business days a order has been in process.
How do I count business days from a start date to today?

 

[Fluff]

You can use Netwrokdays for that, like

=NETWORKDAYS(A2,TODAY())

 

[rentonhighlands]

How do I write
if BL has a value then blank otherwise =NETWORKDAYS(A2,TODAY())

 

[Fluff]

How about

=IF(B2="","",NETWORKDAYS(A2,TODAY()))

 

[rentonhighlands]

=IF(B2="","",NETWORKDAYS(A2,TODAY()))

Did not work.... BK2 has a value, what I want is if BK2 has a value then blank otherwise NETWORKDAYS(A2,TODAY()))

 

[Fluff]

Try

=IF(BK2<>"","",NETWORKDAYS(A2,TODAY()))