Number of work days between two dates entered into a user form text box

G

Guest

Hi all,

I have a user form that has 3 text boxes as follows:

txtStartDate
txtEndDate
txtNoOfWorkDays

I would like for txtNoOfWorkDays to automatically update with the number of
work days (i.e. Mon to Fri) between the dates the user enters in
txtStartDate and txtEndDate.

If possible I would like to automatically display a chart on the user form.

Thanks for your help in advance.

Mas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number of months and days between two dates without approximation 3
Access 2003 - Setting default value of a text box 5
Parameterised query to return all records or those Between two val 2
Parameter Criteria from a forms Text box - 2003 - not working 5
How to calculate the number of days between two dates 3
Calculating days between dates 1
What is wrong with this code? Everything?? 1
Calculate days in a given month between two dates 6

Top