Is that date formatted as text? If yes maybe:

=VALUE(MID(A1,3,2))&", "&EOMONTH(VALUE(LEFT(A1,2)),0)&", "&VALUE(RIGHT(A1,4))