Date Range

[Looping through]

Is there a way to write a formula that looks at a certain date listed in my
spreadsheet and Mark that row somehow for a filter or sort to look at later.

My constant date range will be in cell W2
My changing date cell will be in cells R3:R10000

I want to basically filter and look at only the rows inserted in the last 30
days.

Thanks in Advance
Peter

 

[Pete_UK]

In a helper column you can add a formula like this one:

=IF(R3>=TODAY()-30,"recent","old")

and copy down. Then apply a filter to this column, selecting "recent",
i.e. within 30 days of today's date. I'm not sure what is in W2.

Hope this helps.

Pete