"IF" Question?
Glenn wrote:
Lime wrote:
Any help is greatly appreciated..
I have a column with different dates in it. I need to find the dates
that fall in the month of Aug 2009.
here's what I have
=IF(G2=08/01/2009 and <=08/31/2009, "Y","N")
=IF(AND(G2=--"08/01/2009",G2<=--"08/31/2009"),"Y","N")
Probably better to use this:
=IF(AND(G2=--"01-Aug-2009",G2<=--"31-Aug-2009"),"Y","N")
|