Automated Leave Tracker

Hi I am formulating an automated leave tracker.I have userform that has start date and end date . Both are using date picker fields.How can I calculate the days applied for leave between these two days excluding leaves and specified holidays. Below are my codes. I have a combox3 - which basically states am/pm to state 0.5 days in my textfield(TextBox5) for the application of half day. I don't know how to write code for that as well. I am still a novice in VBA programming. I really appreciate your help in this.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

You can use WorksheetFunction.NetWorkDays to calculate elapsed days excluding weekends and holidays. But you will have to build a list of the holidays. Do you already have that?

Please Login or Register  to view this content.

where holidaylist is a range reference to your list of holiday dates.

For a more comprehensive answer attach your actual Excel file. See yellow banner at the top of the page.

Maybe this:

Please Login or Register  to view this content.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.