Categories Range of Date into MMM-YYYY

Hi all,

I would like to know how to I categories a group of dates into MMM-YYYY based on the range of the date and month only.
Please refer to the attached excel to better understand my problem.

Thanks.

Try below formula in B2 and copy down:

Formula:

Please Login or Register  to view this content.

Thanks, it works!!!

I have another concern, if the cell is not in a date format how to prevent the cell showing "#VALUE!" ?
Can i add something into the formula to have it return the text shown in A3 if it is not a date ?

Please refer to my attached excel for the issue.

Thanks.

Use below formula in B3 and copy down.

Formula:

Please Login or Register  to view this content.

Use below formula in B3 and copy down.

Formula:

Please Login or Register  to view this content.

Use below formula in B3 and copy down.

Formula:

Please Login or Register  to view this content.

oh ****, I think I mistaken my logic wrongly sir.

The date range is suppose to be

Date Range Group
01/01/2015 to 01/07/2015 Jul-15
02/07/2015 to 31/12/2015 Jan-16

01/01/2014 to 01/07/2014 Jul-14
02/07/2014 to 31/12/2014 Jan-15

and NOT


Date Range Group
01/01/2015 to 01/07/2015 Jul-15
02/07/2015 to 31/12/2015 Jan-15

01/01/2014 to 01/07/2014 Jul-14
02/07/2014 to 31/12/2014 Jan-14

Are you able to help me with that ?
Thanks a million.

See the file.