Show upcoming occasions

Hi,

For my studies I have a table:
Rows for courses and columns for number of exercise.
The table is filled with the submission's dates for each exercise.

I want to create another little table that will show me the exercises I need to submit in the next week.
It will take the dates from the table and in one cell will show the according course and in the second cell will show the according number of course.

How to do it please?

Hey Amit,

As per my understanding better go to for conditional formatting than for another Table.

Regards
Danish

First of all, thanks.
But, if you use "small" function, it will return the smallest value from all, and I need the smallest without the "out-of-date" values.
Secondly, I need the exercises' numbers to be changed automatically too.

See the attached file, I added a table for example. I assumed the table is correct for May 15th 2015.
show-upcoming-occasions-exercise.xlsx