I have a tracking sheet for a team whose reporting period is Thursday-to-Wednesday. I'm trying to write a function or macro that can filter all items in a list to show the current week, but based on that Thu-to-Wed structure.

So, for example

A1 is Fri, Sep 18
A2 is Wed, Sep 23
A3 is Mon, Sep 7

If I was running the function today (Mon, Sep 21), I'd want to filter it to show the Sep 18 and Sep 23 dates - since they fall within the range of the "current week" for this team, but not the Sep 7.

Hope that makes sense. I just need something where Excel will look at the current date, figure out where it is in relation to the coming Wednesday, and show me all dates (including today) that fall from the previous Thursday to that upcoming Wednesday.

Date math! Aagh!

Thanks in advance for any help!