Date Range
 

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

Date Range
 

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

On Nov 27, 7:21 pm, Looping through
wrote:
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