WORK DAYS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to calculate lead times based on a Promise Date. If my Promise Date is 5/24/2004, time into deapartment A should be promise date minus 5 workdays. Time into department B should be Promise Date minus 8 workdays, etc. I want to exclude Saturday and Sunday, and I don't much care about holidays. Is there any way to do this programmatically in Access??
Thanks.
 
Take a look at the Date/Time section of "The Access Web"
http://www.mvps.org/access/

There are a couple of different approaches there.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


FRANK said:
I am trying to calculate lead times based on a Promise Date. If my Promise
Click to expand...
Date is 5/24/2004, time into deapartment A should be promise date minus 5
workdays. Time into department B should be Promise Date minus 8 workdays,
etc. I want to exclude Saturday and Sunday, and I don't much care about
holidays. Is there any way to do this programmatically in Access???
 
Back
Top