Have you tried using parameters in a conditional statement? Using parameters would mean you can use a conditional statement but also very easily change the timeframe. If you share a packaged workbook I could try to help further.
Parameters was the exact thing I needed. I can't do exactly what I want (action filters can't modify parameters instead of filtering) but it's close. Thanks!