ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number of work days between two dates entered into a user form text box (https://www.excelbanter.com/excel-discussion-misc-queries/446855-number-work-days-between-two-dates-entered-into-user-form-text-box.html)

No Name

Number of work days between two dates entered into a user form text box
 
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


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com