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.

I don't believe for a minute that you used the formula
=if(A15/1/09and J145/1/2009,May 2009, if(J14<6/31/2009 and J146/1/2009,
June 2009, ...)
as it is choc-a-bloc with syntax errors.

Unless you have a particular desire to use an IF formula, why not
=TEXT(A2,"mmmm yyyy") ?
--
David Biddulph

"John McDonnell" wrote in message
...
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.

=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.

Hi,

You may create pivot table. Drag the dates to the row area. While on any
cell in the date column, click on the pivot table button on the pivot table
toolbar and then select Group and Outline Group. Select months there and
then OK

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"John McDonnell" wrote in message
...
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.