Sheet Summary with Date Ranges

user1234

I have a sheet summary for 4 months worth of data, I would like to be able to populate a separate summary to show only the last 30 days of data. So that I can create a dashboard referencing all the data and a breakdown of the most recent. How can I edit the summary to reflect?

Tried filtering and adding a variation of (< = TODAY)

heyjay

Are you pertaining to using filter in the column headers?

Or you need a formula to count within the last 30 days?

=COUNTIF(
[Date]:[Date], 
AND(
@cell <= TODAY(), 
@cell > TODAY(-30)
))