Calculating weekdays

[Marc]

Hi,

I have a table with two separate date fields. I need to
calculate in a query how many Workdays (excluding
weekends) there are from the first date to the second. In
other words, if Date1 is a Thursday and Date2 is the next
Tuesday, thats 3 workdays.

Is this possible?

Thanks,

marc

 

[Allen Browne]

See the WorkDay math functions at:
http://www.mvps.org/access/datetime/date0012.htm

 

[Marc]

Thanks Allen,

Marc

-----Original Message-----
See the WorkDay math functions at:
http://www.mvps.org/access/datetime/date0012.htm

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

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




.