|Custom Format cells as Zero Zero ( 00 )|
On the tool bar:
In the box under "Type:"
Also you do not need the left function for Month
simply do =MONTH(A1)
The same applies to Day, simply =DAY(A1)
You do not need the YEAR, just =RIGHT(A1,2) will get you