can you use the NETWORKDAY function in Access

[Waffler]

I need to calculate how many working days have passed since processing an
order and dispatching it. I can do it in Excel but am transferring
spreadsheet to an Access database.

Thanks hopefully

 

[Ofer]

There is a post given by Allen Browne

See:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

 

[Arvin Meyer [MVP]]

You can use Excel functions by setting a reference or using late binding.

http://www.mvps.org/access/modules/mdl0006.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.mvps.org/access
http://www.datastrat.com