If blank cel then dont calc Networdays - Formula Not working

[mattbarb]

Hi,

Any ideas why this simple formula wont work:

=IF(COUNTBLANK(I10:J10),"",NETWORKDAYS(I10:J10))

?

Many thanks

 

[steve the fish]

Because that isnt the syntax for networkdays. It requires at least a start date and an end date.

 

[mattbarb]

Hi, start/end date are in the cells. Syntax is correct i think, as per the below.

[COLOR=#2C2C2D][FONT=inherit]=NETWORKDAYS (start_date, end_date, [holidays])[/FONT][/COLOR][COLOR=#2C2C2D][FONT=&quot]



[/FONT][/COLOR]
[COLOR=#2C2C2D][FONT=&quot][/FONT][/COLOR]

 

[Special-K99]

NETWORKDAYS requires a start date and end date separated by a comma.
You have a range and there's no comma in NETWORKDAYS in your formula.