Schedule updating formula stopped working

[Bred0061]

Hi everyone!
Im new to the forum but am hoping that someone can help me... I visited a forum a few months ago looking for help to create a formula that helps me to have a home basketball schedule automatically update as each day passes. This updates three different cells the next Opponent, Date of the next game, and time of the next game. It worked really well last year but now when I try to put in the new schedule it doesn't work anymore can you help?

The formula is =INDEX(Schedule!A:B,MATCH(NOW(),Schedule!A:A,1)+1,1)

I can send the workbook to anyone who thinks they can help me with fixing it and its also attached to this post i think.

If you are looking at the work book its cells c7, e7 and g7 and then the schedule is in the schedule tab

Thank you so much!!

Allen

[mdbct]

The workbook is working correctly when I open it. It currently show the first game to occur after today, which is the game vs the Hawks on Dec 10.. What game are you expecting to see?