Pull list of dates that are greater than a certain date (meets criteria)

**flamewheel** · 06-26-2013, 11:50 AM

Hi everybody,

So I've got a vertical list of dates in M/D/YYYY format, and I'm trying to come up with a method to pull certain dates that are greater than a given benchmark and paste those values in another column. For instance, if I've got a list with 3/3/2008, 5/5/2010, 6/6/2011, and 7/7/2012 I want to pull only the dates beyond 12/31/2010 (so would be the 6/6 and 7/7 ones).

I'm assuming this isn't doable with one formula, so I would need a macro. But I'm having trouble just even coming up with the logical operator for just one date. I must be doing something wrong here. If my date in B2 is 1/1/2009 and I have a formula as IF(B2>12/31/2009,"True","False"), I just get TRUE, which shouldn't be the case.

I'm pretty new at Excel (I wrote my first "big" macro yesterday) so any help would be much appreciated!

**Sam Capricci** · 06-26-2013, 03:37 PM

Instead of doing the IF(B2>12/31/2010,"TRUE","False") you could write if(B2>12/31/2010,B2,"") then it would return the value in B2 if it exceeds your value.

**flamewheel** · 06-26-2013, 05:17 PM

Hmm, that still seems to not work for me--no matter what, the TRUE condition is returned. I've found a workaround to the original question though, so this becomes more of an interesting question to me than a need-to-know. I'll keep hunting for an answer.

**wenqq3** · 06-27-2013, 03:15 AM

Hi flamewheel, welcome to Forum.
Can you upload a sample workbook with remove those sensitive data.
Post a WORKBOOK.
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

**elayaz** · 06-27-2013, 04:56 AM

Hi,

I assume you are having excel 2007 or above. Can't we just use date filters and get the desired results.

See this Pull list of dates.xlsxsheet. Will that work?

**Sam Capricci** · 06-27-2013, 07:23 AM

Unfortunately my excel was down when I wrote the reply so I didn't have a chance to test it. Now that I did, I find that I had to put in a helper cell to get it to work.
So for example, say the dates are in column A starting at A2, I put in Cell B1 12/31/2010 then wrote in cells B2 and down =If(A2>$B$1,A2,"") and everywhere that the date is equal to or less than 12/31/2010 it returns the cell value (numeric, just change it to date, e.g. 40700 which is 6/6/2011) or returns a blank. Worked for me.

**Sam Capricci** · 06-27-2013, 08:49 AM

Also found it will work coded into the formula without a helper cell if you write the date as a number. So if the date you want to see exceeded is 12/31/2010, numerically that is 40543 so if you write the formula as =if(A2>40543,A2,"") and make sure the cell you write that in is formatted as date, it will work returning either the cell in column A or a blank.