patriotpacer
asked on
Calculate Work Days
In MS Access, is there a way to calculate the difference between today's date and 60 days in to the future but ONLY using weekdays?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not if you don't care for Holidays.
/gustav
/gustav
ASKER
Thx. I'll try it here shortly....
You can exclude that check:
Do
datTest = datNext
'''' datNext = DateSkipHoliday(datTest, booReverse)
datNext = DateSkipWeekend(datNext, booReverse)
Loop Until DateDiff("d", datTest, datNext) = 0
/gustav
Do
datTest = datNext
'''' datNext = DateSkipHoliday(datTest, booReverse)
datNext = DateSkipWeekend(datNext, booReverse)
Loop Until DateDiff("d", datTest, datNext) = 0
/gustav
ASKER
tblHoliday