Dynamic Formula Issue

[Tamarissa]

I'm trying to create a dynamic formula that shows the last 4 weeks of data, ending on today's date. I can get the first half no problem, but I can't figure out how to have it end on today's date (there are future dates in the table column).

This is what I have:

=FILTER(Worksheet[Date],Worksheet[Date]>=TODAY()-27)  

Thanks for your insights!

[Bo_Ry]

Please try

=FILTER(Worksheet[Date],(Worksheet[Date]>=TODAY()-27)*(Worksheet[Date]<=TODAY()))

or

=FILTER(Worksheet[Date],ABS(Worksheet[Date]-TODAY()+13.5)<=13.5)

27/2 = 13.5

[Tamarissa]

That works perfectly, thanks!