Thread: NETWORKDAYS Question
View Single Post
 
Old 04-14-2016, 11:33 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
With start_date in A1 and end_date in A2:

=IFERROR(NETWORKDAYS(A1,A2),0) or
=IF(ISTEXT(A2),0,NETWORKDAYS(A1,A2))
Reply With Quote