For each month in a year, I need to generate a weekly schedule based on our week of operation. Our work week [almost always] starts on Friday EXCEPT the 1st of the month, in which case the 1st of the month is the WeekBeginning; and [almost always] ends on Thursday EXCEPT the last day of the month, in which case the last day of the month is the WeekEnding.

In addition to the above exceptions, the first or last work week of the month cannot consist of more than 10 days or less than 3 days.

Can someone please help me find the WeekBeginning and WeekEnding?

Thanks,
CARIE