Did you put quotes around your formula? If so, remove them. Also, the
NETWORKDAYS format is NETWORKDAYS(StartDate,EndDate[,Holidays]) Your formula
has a "-" sign in it as in C30-B30. NETWORKDAYS wants a comma between C30
and B30 as in =NETWORKDAYS(C30,B30) If you are using a version of Excel
prior to Excel 2007, you need to have the Analysis Toolpak installed to use
the function NETWORKDAYS. You don't state what happens when you use the
formula. "can't get it to work" doesn't tell anybody anything.

Tyro


"NotGood@All" wrote in message
...
I have 2 date fields, B30 & C30 and a number field F30. I want to
calculate
the Net Workdays between B30&C30 putting the answer in F30, but if C30 is
blank, I want F30 to be blank. I used this code in F30
"=IF(C30="","",NETWORKDAYS(C30-B30))" but I can't get it to work. Would
someone please help me!
--
NotGood@All