Simple IF Statement Help!

[frank265]

Hi All, this is probably really basic but I'm completely new to IF statements and I haven't managed to find anything online that explains this simple task which I'm trying to do...

Basically I have a bunch of dates in a column in a spreadsheet - let's say they're in column A. Column B is blank and what I'm trying to do is see if the date in Column A falls between two dates. Let's say they're Jan 1st 2014 and 31st Dec 2014. If they fall within that time frame I would like to place a Y in Column B. If not, I would like to place an N.

Any suggestions for the best way to achieve this?

Thanks so much for reading!!

Frank

 

[Mike LH]

Hi,

Put the earlier date in E1 and the later date in F1 and then you can use this. Drag down.


=IF(AND(A2>=$E$1,A2<=$F$1),"Y","N")

 

[frank265]

Great, that's perfect - thanks so much for the quick reply Mike!