Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart displaying weekly data group in months without weekly labels | Charts and Charting in Excel | |||
3 months prior and 3 months post a date | Excel Worksheet Functions | |||
Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
Group data by weeks not months | Excel Discussion (Misc queries) | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) |