Hi all,

This is my second post, i hope your help can solve my problem as my previous one.

So the problem is, i want to automatically extract each of the date, month and year from a previous inputted date format to several different cells.

For Example

in cell A1 i will input 29-march-2013, then i want each of the cells in B1, C1 and D1 automatically inputted by change to each of date, month and year E.g: B1= 29, C1=March or 3 D1=2013.

Many thanks for your kind assistance!