IF to group months

[John McDonnell]

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 J14>5/1/2009,May 2009, if(J14<6/31/2009
and J14>6/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.

 

[David Biddulph]

I don't believe for a minute that you used the formula
=if(A15/1/09and J14>5/1/2009,May 2009, if(J14<6/31/2009 and J14>6/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") ?

 

[muddan madhu]

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

 

[Ashish Mathur]

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