Ok so I am trying to use the DateAdd function but it needs to calculate based on workdays, I figured maybe they considered weekdays the same, but it returns the same result as just using the days interval.
Can someone help figure out how to get it to exclude saturday & sunday?
The code I am using for this event is:
Me.[Due Date] = DateAdd("w", 3, [Date Submitted])
Me.[Update Date] = DateAdd("w", 13, [Date Submitted])
Me.[Dead Date] = DateAdd("w", 16, [Date Submitted])
Where the number specified is actually the number of WORKDAYS that need to be added.
TIA.