I am working on a reporting spreadsheet and need some help. The report needs to show any milestone within +/- 15 days of today (date the report is being run)

The formula needs to work something like this:

From x range of cells in a row find all that are +/- from today and then take the info from the cell left of this.


Any help would be appreciated