Exclude weekends from calculations

[Alex Martinez]

Hi,

I am using this code in my text box. I work for an insurance company. The
first code determines the number of days when an audit is assigned. The
second code is for determining the number of days the audit has been in the
office. My question is on both cases I want to exclude weekend (Saturday &
Sunday) in my calculcation (code) is this possible? Also, if possible how
can I exclude major US holiday's? Any tips will be appreciated. Thank you
in advance.

Number of days assigned
=IIf([Completed] Is Not
Null,Int([Completed]-[AssignedOn]),Int((Now()-[AssignedOn])))

Number of days in office
=IIf([Completed] Is Not Null,Int([Completed]-[Rec'd]),Int(Now()-[Rec'd]))

 

[Allen Browne]

The simplest solution is to create a table with all dates, and flag or
delete the non-workdays (holidays and weekends). You can then count the
number of records in that table between 2 dates.

For a more generic approach, see:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

 

[Amy Blankenship]

This may help
http://www.datapigtechnologies.com/flashfiles/queryworkdays.html

HTH;

Amy