Thanks to some assistance in this site I was able to use the formula below to return a list based on the current day.

=IFERROR(INDEX($A$2:$A$6,SMALL(IF(TODAY()-$B$2:$B$6<=7,ROW(INDIRECT("1:"&ROWS($B$2:$B$6))),""),ROW(1:1))),"")

The formula above returns a list of ID numbers that have dates 7 days from today.
How do I modify the formula above so I can use two criterias that is 7 - 14 days from today.