I've been trying to come up with a cell formula that returns the dates of certain days of a specified month & year depending if Weekly, Bi-Weekly, Monthly, or Semi-Monthly. For example

Cell A1 = 2006 (or could be 2005, 2007, etc)
Cell B1 = Sunday (or could be Monday, Tuesday, Wednesday, Thursday, etc)
Cell C1 = Weekly (or could be Bi-weekly, or Monthly, or Semi-monthly)

Cell A3 = January

Cell A4 = 1-01-06
Cell A5 = 1-08-06
Cell A6 = 1-15-06
Cell A7 = 1-22-06
Cell A8 = 1-29-06

Cell B3 = February

Cell B4 = 2-05-06
Cell B5 = 2-12-06
Cell B6 = 2-19-06
Cell B7 = 2-26-06

To prevent the formula from being overly complex, it may be easier to have a separate sheet for weekly, bi-weekly, monthly, & semi-monthly.

Please help. Thanks so much. mikeburg