Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
return a date from range, date is between dates in two other cells | Excel Discussion (Misc queries) | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |