PLEASE HELP! Finding the right formulas to create the perfect TV Guide!

Hi!

My name is Rebecca. I am attempting to organise my TV Shedule. I have googled and tried to find a good template but just couldnt not find one so i thought i would create one. I just dont know where to start with my formulars. So i was hoping someone could help me!

Here is what i have.

3 sheets.

Sheet 1 - TV Schedule
A pretty looking schedule that tells me what is on in this current week.
This is a sheet with days Mon - Sun and some rows below it. I am missing the following:

1) A formula that populates the latest week's dates under the days of the week with Monday starting the week. e.g. so if i open the spreadsheet on Wednesday it shows wednesdays date and the weeks monday date.

2) in the rows below each day, i wanted the cells to look up the values in another sheet (called Episode Guide). When it looks up the range in the spreadsheet and sees an episode that is set for that day, it returns the shows, this is a concatenated field of the show title and episode number (e.g. Game of Thrones - S03E01)


Sheet 2 - TV Season Guide
This sheet is where the data is entered. List the title and the season, season start date and the number of episodes to the season (e.g. number of reoccurances). the point of this sheet is to say, Game of Thrones is going to be on 12 times starting on 14/07/2013 .. this means that in the Episode Guide sheet (sheet 3) it will know how many occcurances of dates to create.

Sheet 3 - Episode Guide
This is the difficult one! This one somehow (yes, somehow) looks up the season title, start date and number of occurances and creates a row for each episode. e.g. because game of thrones has 12 episodes to a season it would create 12 dates and they would be 7 days appart from 14/07/2013. that way, this spreadsheet becomes a list of every episode and the range for sheet one, which is the schedule.

OK. That seems like a lot now that I have spelt it out but i have created the workbook and formatted it.. i just need to figure out all the formulas.

I have attached what i have done so far (i hope thats ok and not unsafe). No laughing... i know its ambitious and probably cant be done but it would just make life SOOO much easier!

Can anyone help????? Please

2013 TV GUIDE.xlsx