May 27, 2004 #1 dar149 MIS Mar 5, 2002 117 US Does anyone know if the Networkdays function can be used in Access? In help it says it's a spreadsheet function. Thanks...
Does anyone know if the Networkdays function can be used in Access? In help it says it's a spreadsheet function. Thanks...
May 27, 2004 #2 oharab Programmer May 21, 2002 2,152 GB Network days is a spreadsheet function, but you can use for functions at: http://www.mvps.org/access/datetime/date0006.htm if you are just looking at weekends or http://www.mvps.org/access/datetime/date0012.htm which will take an array of holiday dates. hth Ben ---------------------------------------------- Ben O'Hara http://www.RobotParade.co.uk"Where are all the stupid people from... ...And how'd they get so dumb?" NoFX-The Decline ---------------------------------------------- Upvote 0 Downvote
Network days is a spreadsheet function, but you can use for functions at: http://www.mvps.org/access/datetime/date0006.htm if you are just looking at weekends or http://www.mvps.org/access/datetime/date0012.htm which will take an array of holiday dates. hth Ben ---------------------------------------------- Ben O'Hara http://www.RobotParade.co.uk"Where are all the stupid people from... ...And how'd they get so dumb?" NoFX-The Decline ----------------------------------------------
May 28, 2004 #3 MichaelRed Programmer Dec 22, 1999 8,410 US see faq181-261 for a more comprehensive (and complex) soloution MichaelRed mlred@verizon.net Upvote 0 Downvote