I need to determine the working days excluding Holidays and weekends to arrive at a completion Date.
I have a STartDate
Hours to Produce
Days to Produce based on 8hours and 5 Mins per day 5 Day Week
A Calendar in a separate table listing Public Holidays
I have used these custom functions to determine the Finish Date with Weekends and Holidays included.
The Problem is I am not getting acurate dates and it mat be the way I have used these ciustom finctions.
I have looked for a custom function that will give me a combination of the above two.In fact WeekDays offset looks right except it does not include Holidays.
I have attached an example..which is NOT working as I think I have used the custom functions incorrectly , however perhaps it will serve to clarify.