Access: calculate field on FORM to exclude weekends & holidays

[tmichler]

I have searched, but everything I'm finding is not really answering my question.

I have a field on a form that is calculated when a chk box is clicked. It is calculating a date to follow up that is 35 days in the future. I need this date to exclude weekends and my company's holidays. I have a separate Holidays table ready. I am not able to figure this one out, can anyone help? I need to get this working on a few different check boxes, actually, which all affect the follow up date.

This is the existing code which works fine, just doesn't exclude weekends or holidays.

Private Sub Checkdaysuntilfollowup_Click()
If CheckDaysUntilFollowup.Value = True Then
[F/U Date].Value = date + [Days Until Follow Up]
ElseIf CheckDaysUntilFollowup.Value = False Then
[F/U Date] = Null
End If
End Sub

[nico5038]

Check out: http://www.mvps.org/access/datetime/date0006.htm
Many fine other samples too :-)

Nic;o)