NETWORKDAYS with NOW() or TODAY()

R

rerhart

I currently have two columns of data:

Ordered Date (C)
Complete Date (D)

Both are columns of dates. In some cases the Complete date is empt
and when it is empty I would like my existing formula to also calculat
the number of weekdays between the Order Date and Today's Date. Belo
is my existing formula that works fine for calculating weekdays betwee
the two dates, but I am not sure how to add the functionality o
calculating weekdays between Order Date and Today's date if th
Complete Date is blank.

=IF(OR(ISBLANK(C2),ISBLANK(D2)),0,NETWORKDAYS(C2,D2))

Thanks
 
F

Frank Kabel

Hi
try:
=IF(ISBLANK(C2),0,IF(ISBLANK(D2),NETWORKDAYS(C2,TODAY()),NETWORKDAYS(C2
,D2)))
 
Top