IF to group months

  • Thread starter Thread starter John McDonnell
  • Start date Start date
J

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.
 
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") ?
 
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
 
Back
Top