I can see that we're going in lots of different directions with this passage...
While I believe this to be an overlay with multiple fulfillments, let's look at it in the context of Christ's ministry. And, just for kicks, let's try taking it literally - as a literal week - instead of symbolically as a seven year period, and see where that gets us.
What we have is a one-week period that Christ is in Jerusalem. In the middle of the week, He is crucified. At the end of the week, He is resurrected from the dead. THAT is the covenant that He confirms.
We have the following:
* In John 12:1, we read that "Jesus came to Bethany six days before the Passover." Now, according to Exodus 12, this is the fourteenth day of the first lunar month of the biblical year. However, in the time of the first century, the Passover observance had been changed and many people kept a
national Passover observance (instead of a family-based observance) on the fifteenth instead of the fourteenth. This was based on the national Passover observances in the time of King Hezekiah (2 Chron. 30) and also in the time of Josiah (2 Kings 23:21-23; 2 Chron. 35:1-19). Although there were many Jews in the first century who kept the 14th Passover, we can know that John was speaking of the 15th Passover here because in John 18:28, we find mention of "the Passover" on the day after Jesus ate an apparently 14th Passover meal according to John 13:1-2. Therefore, Jesus came to Bethany on the ninth day of the first lunar month, six days before the 15th Passover.
* The day that Jesus entered Jerusalem was the day after He arrived at Bethany. See John 12:1 and 12. So Jesus entered Jerusalem on the 10th day. This was the day when the people cried "Hosanna!" to Him and put down palm branches in the streets.
* Jesus entered into Jerusalem riding on a donkey on one day, and although He entered into the Temple on that day, He didn't overturn the moneychangers' tables until the next day. See Mark 11:1-19. So Jesus overturned the moneychangers' tables on the 11th day.
* The fig tree withered on the day after Jesus' overturned the moneychangers' tables. See Mark 11:20. This was also the day that the Pharisees asked Him by what authority He did these things, continuing on through His private discourse with the disciples concerning the sign of His coming. See Mark 11:27 through the end of chapter 13. This was the 12th day.
* Two days later was the 14th Passover. See Matthew 26:1-2 and Mark 14:1. Remember that in the bible, a day begins at sunset. Jesus ate the Passover with His disciples on the evening beginning the 14th, and was crucified the following afternoon, which was still the 14th. He was buried immediately prior to evening beginning the 15th.
* Jesus was in the tomb three days and three nights. So He was resurrected just before the evening beginning the 18th.
* The following morning, which was Sunday morning, the women discovered the empty tomb.
Backtracking to figure out the days of the week for all of the above events, we have Jesus entering Bethany on Friday the 9th. He entered Jerusalem on Saturday the 10th - sorry, it wasn't "Palm Sunday", although since Jesus entered the Temple twice, I can see how the confusion originally occurred. He cast out the moneychangers on Sunday the 11th. He ate the Passover meal on Tuesday evening and was crucified on the afternoon of Wednesday the 14th - in the very middle of the week. He rose on Saturday evening and was seen on Sunday morning.
I already know that there will be quite a few people who will object to this chronology, as they are inclined towards a Friday crucifixion. Please understand that I've already seen all of the chronological arguments in favor of a Friday crucifixion and have already dealt with them in my own studies, so there's really nothing you can point out that I haven't come across before. Plus, this neatly explains Daniel's "one week" and so should be seriously considered without rejecting it out of hand.
By the way, there was an earthquake when Jesus died (Mat. 27:51) "in the midst of the week" which tore the veil covering the Holy of Holies in the Temple. Until this was repaired, the Jews couldn't offer sacrifices at the Temple, so sacrifices literally ceased for a period of time. Compare Daniel 9:27. Of course, the Temple sacrifices ceased entirely when the Temple was destroyed forty years later, but that doesn't fit the time context of Daniel's prophecy.
FYI, the Exodus from Egypt occurred right about the time that Jesus was buried in the tomb - right towards sunset, the beginning of the 15th day of the month - and they crossed the Red Sea during the day portion of the 17th, reaching the other side right about the time that Jesus was resurrected, on the evening beginning the 18th.
But that's another story...
Damon