workingdays

[tglock19]

If an incident occurred on a given date and the report is due 15 business
day I need a query to return the date on which the report is due

 

[PC Datasheet]

The first thing you are going to need are a table of holidays and a table of
non-business days for your company so you can exclude the days in these
tables that are within 15 days of the incident date.

 

[Michel Walsh]

Hi,

You can also take a look at
http://www.mvps.org/access/datetime/date0012.htm for many functions dealing
with working dates.



Hoping it may help,
Vanderghast, Access MVP