By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,709 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

How to calculate 6 business days past a specific date?

P: 26
I'm working in an Access XP database and I need to create a query which calculates what the date will be 6 business days after [Rescind_Date]. I have no idea where to start and most posts I find on calculating business days pertains to subtracting data in two date fields. I can build an expression in my query to add the date, Date_Due:[Rescind_Date] + 5 but that doens't address the business days.

Thanks in advance!
Feb 4 '11 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,338
If the Weekday() of the date you trying to calculate is 7 (ie Saturday) add 9, if it's 6, add 10, otherwise add 8.

If you need to account for holidays, then you'll need a table of holidays.
Feb 4 '11 #2

gnawoncents
100+
P: 212
Check out the "Counting the Number of Working Days in Access 2007" article at the address below

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
Feb 4 '11 #3

P: 26
Excellent! Thanks for all the help/guidance!
Feb 4 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.