How to re format a date label

[Pingbat]

Good Afternoon from 14 degrees C about to rain Wetherby UK :-)

A third party program ( http://i216.photobucket.com/albums/c...ps4f8e9039.jpg ) is exporting date ranges in this format:
Month from 2012-05-04 to 2012-06-03. My question is please how coumd I change this: "Month from 2012-05-04 to 2012-06-03" to "May 2012"

Thanks in advance,
David

[Miraun]

Hi David;

Assuming that it's consistently that same verbiage, you could give this a shot:
=TEXT(MID(E16,12,10),"MMMM-YYYY")

[Pingbat]

My head is mushed and I just can get this date format
Month from 2012-05-01 to 2012-05-31 changed to May 2012 :-(

Thank you for giving me this formula: =TEXT(MID(E16,12,10),"MMMM-YYYY")

Ive illustrated my problem here:
http://i216.photobucket.com/albums/c...psab8f4cae.jpg

If any one has the patience please give me an idiots guide to what i should do with the formaul, all attempts over the last hour have failed :-(

Thanks in advance,
David

[VKS]

Hello Pingbat, How about and excel instead of a pic.
Best Regards/VKS

[Kevin UK]

Hi Pingbat

Try the following, changing the cell refernce "E16" to "A126".

Please Login or Register  to view this content.