Date Query

[Nikila40]

How do I query the number of days (weekdays, not weekends)
between two dates (i.e., in excel, I use "=NETWORKDAYS
(b4,c4)-1").

Also, can this be done in a query field rather than in the
code (VB)? I'm not good at coding....

Thank you so much!

 

[Allen Browne]

Copy the code this link into a new module:
http://www.mvps.org/access/datetime/date0012.htm
Save the module with a name such as Module1, and you can then you can use
dhCountWorkdaysA() as if it were a built-in function.

 

[Nikila40]

I think I'll stick to Excel..... Thanks!

-----Original Message-----
Copy the code this link into a new module:
http://www.mvps.org/access/datetime/date0012.htm
Save the module with a name such as Module1, and you can then you can use
dhCountWorkdaysA() as if it were a built-in function.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.