I have a spreadsheet that I use each month. Within each month, I need to have the dates of all Mondays, Tuesdays, Wednedays, Thursdays, and Fridays in that month. Right now, I manually enter each date under the columns corresponding to that day of the week. My spreadsheet right now looks like this:
A30: Monday
B31: needs to be the first monday of the month
B32: needs to be the second monday of the month
B33: needs to be the third monday of the month
...
B38: needs ot be the first Tuesday of the month
...

Any help would be greatly appreciated. Thanks!