Hi Emily
Subject pretty much says it all. I am trying to find out the number of
work days between two dates. I found the syntax I need in the help
section but get a 0 value so I am assuming I need the Analysis AddIn.
However, I can't find it anywhere. Where do I find this??
You need to make sure that your dates are in the correct format.
You can do this either by putting the dates into cells, and referring to
the cells in your formula, or by enclosing the dates in quotes, for example
=NETWORKDAYS("1/12/1934";"5/12/1934")
returns the value 3 (when using Australian date format).
Hope this helps.
Adrian
www.tryanotherangle.org
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
