Determine end date using start date and business days

[riggsd]

What is the best way to determine a due date based on a start date and number of business days?

Most of my due dates are based on calendar days so this isn't an issue since I can just add the number of days to the start date but a few due dates are based on business days so need to calculate the end date based on business days for these items.

For example, if an item is delivered on 10/23/14 and it requires 10 business days to review, then the due date needs to be 11/6/14.

Thanks in advance.

 

[Joe4]

I think it is going to require some VBA. Access doesn't have the same WORKDAY and NETWORKDAYS function like Excel does.
See: Question Due date - Working Days - Access World Forums

 

[riggsd]

I realize I'll need VBA, I just don't know how to do it.

 

[Joe4]

I realize I'll need <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>, I just don't know how to do it.

Read through the link I provided. That should give you the VBA code you need. There appear to be a few variations on how to do it, so choose the one that most suits your needs.

All you need to do is copy the VBA code into a VBA module in Access, and then you can use it from that Database like any other "inherent" Access function.