Creating a view by filtering 2 columns by date (both within 3 months of today's date)

Hi all,

Trying to do a linkback from another post located here but not having much luck doing it: http://www.excelforum.com/excel-form...days-date.html

I'm working with 2 date columns and trying to filter a view to only include projects with dates within 3 months of today's date.

I've attached a current working file of the data and the end result i'm hoping to achieve via a macro of some sort.

I've manually got it to work via formula by inserting 2 additional columns (highlighted yellow) which determine if the dates "YES" fall in this 3 month time frame of "" blank if not.

Hoping to create a macro which does all of this automatically without modifying any columns if this is possible

Hello

A suggestion using advanced filter.

Please Login or Register  to view this content.

Let's try this then.

Please Login or Register  to view this content.

You are welcome and thanks for the feedback & rep.

All much appreciated!