NetworkDays formula implementation

Oct 22, 2010 at 12:57 PM

Hi NPOI Team


I would like to know how one implements the NetworkDays formula (ATP)?

The following gives me an error;



HSSFCell cell = row.GetRow(0).GetCell(0);

cell.SetFormulaCell("NETWORKDAYS(L9,TODAY()), -1");

I get the following error:

FormulaParseException: Name 'NETWORKDAYS' Is completely unknown in the current workbook



Nov 8, 2010 at 11:01 PM

What's this function used for? Any detailed description.