GMaxey, I didn't see your previous post. I was busy studying your code! I appreciate your help. And right now, I don't want you to write any more code for me because I want to do it. But I do need your help understanding the format/syntax of




fcnAdvancedDate(Optional StartDate As Variant, Optional DaysToCount As Long = 14) As Date


Later, I think I will be able to add another Select Case to your code for the Holidays found on the Weekends. And later I will figure out how to choose Friday or Monday for the day off work in those cases when the holiday falls on a weekend.


If the holiday falls on Saturday, the day off work is always Friday.
If the holiday falls on Sunday, the day off work is always Monday.


But I've got to do it one step at a time, get one thing working well, then do the next step.


Thanks again,