Determine the date of the business day from the business day number
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.
You mean date + 5 business days? So if today is Wednesday and fri is a holiday then 5 business days later is next Thursday?
ASKER
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.
ASKER
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
Sandra
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 ?
is it 4/1/2011 + 5 BD = 4/7/2011 ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Have been pulled to another problem, but will try these suggestions out tomorrow.
Sandra
Sandra
ASKER
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
Sandra
You are welcome!
/gustav
/gustav
what is a DB of 5?