Text to collumn

Hi,

I have a very simple problem but can't solve so please help me.

Problem:
In cell A1:31.01.2014
I want B1 should be 31, C1 should be 01 and D1 should be E1
By formula not using text to Collumn shortcut in excel.

Regards,
Amit Kumar Roy

=left(a1,2)
=mid(a1,4,2)
=right(a1,2)