Business day calculation is a pretty common question. Please do a search
before posting a new thread in a newsgroup and you will often find your
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14060
answer. From a previous post on the topic...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14060
Arvin Meyer has some code on his site you might find useful:
http://www.datastrat.com/ and go to Downloads>CodeDownloads :
GetBusinessDay.
A very straightforward function where you supply today's date and how many
Bdays in the future/past you want returned. It requires a "Holidays" table.
--
Rick B
"KRDitch"
wrote in message
news:EA8F17A5-906E-46E6-A8C4-0F0DEE662FB2@microsoft.com...
> how do you put in a number calculation to count the # of work days Mon -
> Fri
> from the date that the information was sent or keyed in to the system?