Hello, first off I am new to this forum, and I hope that this is the right place to post this topic, if not I apologize now.

Now for my question, I am fairly new to the Advanced Filters in Excel and while I have a pretty good handle on how it works I am struggling to figure out how to use it in combination with the TODAY() function.

Specifically this is what I want to accomplish. I have a set of data and in that data are dates related to the expiration date for a contract. I want to use the Advanced Filters to move this raw data to a specific sheet and have it only show the contracts that are going to be expiring in the next 60 days from today's date.

I understand how the TODAY() function works, but I can't seem to figure out how to make that a criteria that can be used as part of my Advanced Filter. I thought I would just put in the two following criteria:

>=TODAY() and <=TODAY()+60

I know that to do the "and" part of that I would put them in one row on two columns, so say cells A2 and B2. I have tried that both with Headers and without, but it doesn't do what I want it to do.

I know this is probably simple, but I am missing it and can't figure it out. I understand that the Advanced Filters needs to have formulas that return a "TRUE/FALSE" response, but I thought these would.

Any help would be greatly appreciated. I have attached a sample sheet that I am working on to try and do this. I have the "criteria" on the last tab called "hidden data".
So, for my specific sheet, that is attached, I want to take the raw data from the "Master" tab and move it to the other tabs. I can and already have it move based on "active" or "inactive" and that works. I am just stuck on the ability to move it by date as I stated above. I want to move the raw data from the "master" tab for any contracts expiring in the next 60 days and that date is coming from Column-C on the master tab.

PS License Agmts with Index Providers Term Dates Provisions - May 2013.REV-.xlsm

Thanks,
Phil W.