NETWORKDAYS function has been around through many versions of Excel

In older versions it is part of the Analysis Toolpak which must be loaded
through ToolsAdd-ins.

Then it will work.


Gord Dibben MS Excel MVP


On Fri, 21 Aug 2009 12:38:04 -0700, Gibbyky2
wrote:

here goes

i use excel 2007 and can calculate number of days between 2 dates using
networkdays function. but my colleagues use older versions of excel and
networkdays function does not work

i want to work out the example below as an example

1st date = 09/10/09
2nd date = 23/10/09

this equals 10 working days, i then want to be able to calculate the number
of days by 7.4 (average hours worked per day)

many thanks