Excel 2007 : Shifting cells based on data from a cell whose position varies (part 2)

Hello again everyone,
I posted a thread on 11/6/2009 concerning a Bible reading program I was trying to create. I have decided to revamp it after some help from donkeyOte and darkyam.Basically I have a particular passage that needs to be read on a Sunday (always Sunday), although the date will vary from year to year. I have a start date that the majority of the sheet is calculated off of (E1), the date that the Sunday falls on that particular year (E2), and that day's reading (F2). I also have a range of cells in which the Sunday could fall (E22 - G26) where the formula differs (more on this in a minute), and finally a range of cells (K2:K18) that contain passages that will have to shift based on where F2 falls. I have taken formulas supplied by darkyam fron my earlier thread, and through some trial and error I have adapted them to this new sheet. I hit the wall when I came to the cell after the cell whereF2 fell (G25). The formula that had been working stopped and any variation that I have tried returns various errors. I tried nesting "IF" functions but I don't think I'm doing it right. The formula that is in cell G25 is my most recent variation. Also can someone explain the formula that returns the dates (A6 for example)? It works, I would just like to know why,
so I can understand better.
Thanks so much.