"IF" Question?

Lime · Oct 21, 2009

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")

Mike H · Oct 21, 2009

Hi,

=IF(TEXT(G2,"mm/yyyy")="08/2009","Yes","No")

Mike

Glenn · Oct 21, 2009

Lime said:
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")

Lime · Oct 21, 2009

Thank you.. Stay AWESOME!!!!

Mike H said:
Hi,

=IF(TEXT(G2,"mm/yyyy")="08/2009","Yes","No")

Mike

Glenn · Oct 21, 2009

Glenn said:
=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")