View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John McDonnell John McDonnell is offline
external usenet poster
 
Posts: 1
Default IF to group months

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.