=TEXT(J14, "mmm-yyyy")
or
custom format for cell J14 "mmm-yyyy"


On Oct 26, 5:21*pm, John McDonnell wrote:
Hello,

I'm looking for an IF statement that will organize my data much more
effectively. *I have several hundred dates, and want to group them by
month, but i cannot seem to do so. *For example:

5/22/2009 - May 2009
6/2/2009 - June 2009
5/5/2009 - May 2009
2/5/2009 - Feb 2009

I have tried =if(A15/1/09and J145/1/2009,May 2009, if(J14<6/31/2009
and J146/1/2009, June 2009, ...) but it doesn't work i can only get
the first set of data to work to output May, i can't get anything else
to come out...any thoughts?? Thanks.