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

Working Days

P: 15
Hi,

Im trying to work out how to return a date based on addition of working days only.

On the userform the user enters the date using dtpicker. They then have the option to add 5, 10 or 15 days. I need this to then return the date, adding only the working days, in a new Text box.

Any deas?
Jun 18 '08 #1
Share this Question
Share on Google+
2 Replies


jeffstl
Expert 100+
P: 432
You need to use the VB Date manipulation functions

DateDiff Tutorial
Jun 18 '08 #2

kadghar
Expert 100+
P: 1,295
if you want to make your program calculate holidays (like Easter), or some other special days, there's a really nice algorithm (Gauss's, of course) you can find here:

http://en.wikipedia.org/wiki/Computus

I think you migh find this useful in case you want to consider them as non-working days.
Jun 18 '08 #3

Post your reply

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