I have been searching all ofer and can not find/figure out how to calculate the number of work days between two dates excluding holidays based on a 4, 5, 6, or 7 day workweek. I have the following code now that works for a 5 day workweek but I can not figure how to revise it to work for the 4 day, 6 day and 7 day workweeks. Any help would be greatly appreciated.
VBA Funtion as follows:
Code:
Public Function Workdays(ByRef