Option Boxes, Start Date & Foreground Coloring

Sorry for such a long post, but can anyone help me workbook attached.

Thanks in Advance

I have a calendars worksheet on which I want to use a foreground color to mark paydays for various pay day frequencies and occurrences, using options in option groups.
The problem is how do I get foreground colors for paydays, depending on options selected in two option groups and a Start Date, where Option Group 1: Weekly, Bi-weekly, Semi-Monthly, Monthly; where Option Group 2: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday; and where a Start Date is entered in a cell.

For example, I select Weekly in OG1, select Thursday in OG2, and enter 1/7/2010 (first Thursday of 2010), then programming color Thursday of every week (1/7/2010 to end of year) a certain foreground color. In this case, regardless of the day of the week chosen, foreground color for this day, in every week of the year, is colored. If Wednesday was selected, date would be 1/6/2010.

In another example, I select Bi-Weekly in OG1, select Friday in OG2, and enter 1/1/2010 (first Friday of 2010), then programming cause every other Friday, beginning at 1/1/2010 to have a certain foreground color. In this case, first payday Friday could be 1/8/2010, with every other Friday, including this one, to have a certain foreground color. In this example only first or second Friday (or whatever day selected) of the year should be entered as Start Date, but any day can be selected

In yet another example, I select Semi-Monthly (paid twice every month) in OG1, no selection is necessary in OG2 or the day (Sun, Mon, etc) on which the 1st day of January fall could be selected, enter Start Date of 1/1/2010, then the programming cause Start Date and the day/date which is 14 days ahead (the 15th) to be foreground color coded. The only other Start Date could also be the 16th, with the 30th or last day of month (February).

In the final example, I select Monthly in OG1, no selection is necessary in OG2, but the Start Date entered is the pay date and the date where foreground is colored in every month. In the case of February, which only have 28 or 29 days, if the 30th or 31st is the Start Date or payday, then the default is last day of February.