I have an importrange array to get data from alot of sheets. I organise zhem into one list and then make calculations from this list.

WORKBOOK

however:

• tracker sheet does not contain today's date so A2 needs to be a valid date
• dates on tracker sheet are in column B so B4 cant be A
• query will then look for where Col2 where dates are
• and query is picky on dates if they are not in this format: yyyy-mm-dd