We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Determine the date of the business day from the business day number

Medium Priority
616 Views
Last Modified: 2012-05-11
I can determine the business day to date of the month, that is, if I pass in the start date adn end date.  Howver, how would I go about determining the business DATE if I pass in the business day number?  That is, if I have a DB of 5, how do I get the date this business day number represents?  I have a holiday schedule and this must all be done in VBA, Access 2003.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
in plain English
what is a DB of 5?
Aaron TomoskyDirector, SD-WAN Solutions
CERTIFIED EXPERT

Commented:
You mean date + 5 business days? So if today is Wednesday and fri is a holiday then 5 business days later is next Thursday?
Sandra SmithRetired

Author

Commented:
Sorry, I get so wrapped up i forget when I use company vernacular.  BD is business day, which excludes weekends and holidays.  Yes, aarontomosky, you got it.
Sandra SmithRetired

Author

Commented:
Basically, the approach is between, say 4/1/2011 and 4/30/2011, what date is BD 5? or whatever BD number is inputted.

Sandra
CERTIFIED EXPERT
Top Expert 2016

Commented:
with the date between  4/1/2011 and 4/30/2011, what should be the date  with BD 5?

is it 4/1/2011 + 5 BD  = 4/7/2011 ?
CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Sandra SmithRetired

Author

Commented:
Have been pulled to another problem, but will try these suggestions out tomorrow.

Sandra
Sandra SmithRetired

Author

Commented:
Actually they both worked, but for different clients and different reasons.  Am splitting as I did use both solutions - However, the more complex did allow greater flexiblity in some of the situtations I needed so slightly more went that direction.  Thank you both.

Sandra
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
You are welcome!

/gustav
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.