How can I have a cell on one sheet automatically include text based on a value on another sheet, when it is affected by date, from week to week?

Example: Weekly planner changes each week. As the week for feb 10 - 16, arrives, it shows Thursday the 14th, as an anniversary, based on a list of dates and descriptions on sheet 2.

Any suggestions?