If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Networkdays problems in 2007

Thread starter HandyTralee
Start date Mar 20, 2010
Tags

2007 excel formula function

HandyTralee

New Member

Mar 20, 2010

I have a worksheet that uses the Networkdays() function. In Excel 2003 I had to use the Analysis Toolkit Ad-in to get it to work. In Excel 2007 the Networkdays() function is native but I still, randomly, get an error where my Networkdays () formula gets converted to an #N/A error. If it retype the formula again it works fine.

As this workbook is used by many people in the company I am taking quite a bit of flack at the moment and cannot exoplain the error - or the fix.

Any thoughts?