Convert Date " yyyymm" through Formatting

Hi,

As always with these things we really need to see a complete example in the workbook itself. Particularly since dates are concerned.

It's not clear whether your 'date' is a proper date number or just a text string. i.e what's actually in the cell not what does it look like. Is it a number, say 41740, or text 11042014. Use =ISNUMBER(A1) to test it.

If it's a number then format it as "mm". If it's just text then you will need some function to extract the month bit of it. However upload the workbook for a more definitive response.