Date Issues

[Trace Mathis]

I have a need to calculate a date 15 days into the future
not including weekends or holidays from the current date
and have that be the due date for an order. I find that
NETWORKDAYS is lacking.

 

[Larry Linson]

I have a need to calculate a date 15 days into the future
not including weekends or holidays from the current date
and have that be the due date for an order. I find that
NETWORKDAYS is lacking.

NETWORKDAYS is an Excel function, so a newsgroup devoted to Excel would be a
better place to ask than this newsgroup which is devoted to Microsoft Access
database software. I'd suggest, when you do find the proper newsgroup, that
you be more specific than "is lacking" -- tell them "what is lacking" or
"how it is lacking" or they won't be able to suggest something that may fill
your needs.

It appears to calculate the "net working days" between two given dates
rather than calculating a date X "net working days" from a given date. If I
had to guess, I'd say that it isn't "lacking" but is "inappropriate" to your
needs.

Larry Linson
Microsoft Access MVP

 

[John Vinson]

I have a need to calculate a date 15 days into the future
not including weekends or holidays from the current date
and have that be the due date for an order. I find that
NETWORKDAYS is lacking.

As Larry says, NETWORKDAYS isn't an Access function, it's an Excel
function. Maddeningly, it's listed in the Help files for Access VBA
without any clear indication that it's not available (without extra
work).

See http://www.mvps.org/access/datetime/date0012.htm for an Access
solution. You'll need a table or array of the holidays that your
company observes, of course.