Datediff

D

Dahlman

I have 2 dates. one is for Last day and employee worked before an injury and
the other is the first day back from that injury so I compute how many days
the employee was off due to the injury. I have the calculation to give me the
amount of days however I want to know if it's possible to have the formula
exclude weekends. Thanks in advance. Hopefully you can help me.

Travis
 
D

Dirk Goldgar

Dahlman said:
I have 2 dates. one is for Last day and employee worked before an
injury and the other is the first day back from that injury so I
compute how many days the employee was off due to the injury. I have
the calculation to give me the amount of days however I want to know
if it's possible to have the formula exclude weekends. Thanks in
advance. Hopefully you can help me.
Click to expand...

You need a user-defined function for that. Fortunately, several
such have been written already. Here are some functions for doing
"workday math":

http://www.mvps.org/access/datetime/date0012.htm
 
Top