Filter by various dates 30, 60, 90 days in the future

**sandiegobeach** · 10-21-2012, 08:16 PM

Hello,

I have two columns in Excel. Column A = Names. Column B Dates. I would like to filter the data so I can only see upcoming dates within 30 days from the current date. The same thing for 60 days, and 90 days. By doing this I can then start contacting the clients that are within 30 days, 60 days, and 90 days. Any help would be great. I'm using Excel 2010. I am familiar with Tables and Filters. I'm not sure if custom filter can achieve this task? If so, please explain. Thank you.

**FDibbins** · 10-21-2012, 08:42 PM

i dont know if 2010 can do this, but i know 2007 date filter will not accept a formula.

if 2010 can do this, enter the following into the date filter option...
=TODAY()+30
if 2010 wont accept a formula either, you will just have to use the date filter options and select the date you want from the pull-down

**sandiegobeach** · 10-21-2012, 08:50 PM

Unfortunately it doesn't accept formulas. Thank you for trying.

**FDibbins** · 10-21-2012, 08:54 PM

yup, sorry, didnt think so

**sandiegobeach** · 10-21-2012, 09:18 PM

How about converting my spreadsheet into a database in Excel? If I have a criteria and extract. I wonder if that would work. I'm not sure what I would put in my criteria?