NETWORKDAYS function

[kippers]

I hjave installed the data analysis tool but this function (and the WORKDAY
function for that matter) do not work. By this I mean that when I type in the
function =NETWORKDAY or =WORKDAY and open the brackets it does not seem to
recognise it as a function.... any ideas?!

cheers,

 

[Mike H]

Persevere because it doesn't on mine either but the formula still works.

=NETWORKDAYS(A1=TODAY())

Formatted as general

Mike

 

[Mike H]

and that should be

=NETWORKDAYS(A1,TODAY())

Persevere because it doesn't on mine either but the formula still works.

=NETWORKDAYS(A1=TODAY())

Formatted as general

Mike