Thanks. But say for instance I have a list such as below starting on row 3. I have the date on row one. I want to use that date in row 1 cell E1 to do a vlookup or a formula to look at the data range and only show me the rows that has a maturity date greater than Mar 14. How do I go about doing...
Hi I have a range of data that I would like to filter using the current day's date and have all the lines that are greater than today's date show and any lines less than today's date be hidden. What formula will work?