I'm trying to create an IF statement to omit certain data

So i'm creating a dashboard and a requirement for that dashboard is to show what reports are due within 7 days. I have around 300 entries (they span 12 months and get filled in as they go) and can only get it to work by having a table that is 300 boxes wide, with tons of white space or '#VALUE' notifications. I saw a post somewhat like my problem but wasn't nearly as complex. SOME BACKGROUND INFO - Once you put a date into the 'Inspection End Date' cell, a new date (which is 21 days later) pops up into the adjacent cell, and that is the date that the report is due. What I need, is a formula that will scan those columns, from row 8 to row 319, and if the report due date is within 7 days of today's current date (which i just use (TODAY()+7)), then the Bridge ID, Cells C8-C319, are put into a nice little table on a different sheet (the sheet is called Dashboard). An extra would be that if the due date has passed without a date being entered into the 'Report Submitted' column (basically just being late), then having that bridge ID coming up into another table (on that Dashboard sheet) for late reports.
Thank you so much!!

Hi, welcome to the forum

Always better to upload a sample file, rather than a pic, we cant work with pics

However, if you want to pull in data from specific column/s, take a look at using INDEX/MATCH/MATCH - include =TODAY()+0, TODAY()+1 etc (or reference TODAY() instead)

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

So what would a sample answer look like?

Im a little responding, sorry, RL interfered (Im having my garage re-wired)

Try this ARRAY formula to pull the "within 7 days" part...
=IFERROR(INDEX('Sample Data'!$B:$B,SMALL(IF(('Sample Data'!$D$2:$D$10<=TODAY()+7)*('Sample Data'!$E$2:$E$10=""),ROW('Sample Data'!$A$2:$A$10)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Then copy down

Use the same thing for the dates, just change the bolded part. If you want to make this a bit more flexible, instead of hard-coding 7, put the 7 in it's own cell and reference it, that way, you can see 1 day out, 7 days out, 10 days etc, just by changing that cell.

The 2nd table should be the same thing, give it a go and let me know how you make out?