Need formula to change dates based on given year

Hey guys. I am not too experienced with Excel. Took a class, I get the gist, but I'm still learning.

This spreadsheet is used to schedule music leaders for my church.

I would like to tell my worksheet what year it is and have all the dates change in each column. If there is not a 5th weekend in the month, I would like to show "-".

In the first week, if either the Saturday or Sunday falls in the new month, I consider that week 1. That's why the first week in September reads "Oct 31 & Sep 1)

I need the formatting to read "31 & 1"

I have come mildly close to figuring this out, but am still having trouble. Can any one help me figure this out? It is a challenge I would love to work out.

I've included the worksheet in case you would like to take a look.

Thanks in advance.

-Keith

Screen Shot
Setting Up Automatic Date Change.png

Worksheet
Worship Leader Scheduling-2013.xlsx