Filter dates according to current date

**babbeleme1** · 06-20-2013, 03:19 PM

Hi All,

I'd like to create a function that will filter my excel sheet to only include Column J dates that are within 90-days of the current date, whatever that may be at the time it is generated.

Is there a way to program this in macros?

Thanks in advance!

**AlphaFrog** · 06-20-2013, 03:49 PM

Please Login or Register  to view this content.

**babbeleme1** · 06-20-2013, 04:51 PM

Thank you AlphaFrog! This was very helpful.
Why did it end up including April-September? How can I make it only today until 90 days from today, (i.e. June 20th - September 20th)?

**AlphaFrog** · 06-20-2013, 04:57 PM

Originally Posted by babbeleme1

Thank you AlphaFrog! This was very helpful.
Why did it end up including April-September? How can I make it only today until 90 days from today, (i.e. June 20th - September 20th)?

I don't know. Can you post and example workbook?