ExcelBanter - NETWORKDAYS function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - NETWORKDAYS function (https://www.excelbanter.com/excel-discussion-misc-queries/147022-networkdays-function.html)

kippers

NETWORKDAYS function

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

NETWORKDAYS function

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

=NETWORKDAYS(A1=TODAY())

Formatted as general

Mike

"kippers" wrote:

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

NETWORKDAYS function

and that should be

=NETWORKDAYS(A1,TODAY())

"Mike H" wrote:

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

=NETWORKDAYS(A1=TODAY())

Formatted as general

Mike

"kippers" wrote:

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,

All times are GMT +1. The time now is 03:01 PM.