Hi all,

Looking for what I think may be a simple solution but can't get my head around it. Basically I have workbook that I am using to keep track of employee PTO. I created a user form that allows me to add in requests for time off using combo box with names, DTPicker for date requested, an input box for the total hours requested and a option button for the type of hours. Once submitted the information is written to the worksheet Add_Days Off by looking up the DTPicker value in column A (List of all dates in the calendar year) and once found puts the name, type of hours and # of hours off for that date. This works well but what I would like to do is to be able to have 2 DTPickers and calculate what dates have been requested excluding weekends and holidays and write to the appropriate cells. I've seen a lot of code to calculate workdays but I'm not sure how to incorporate into this. Any help would be appreciated!

Thanks,
Steve