Use formula to create a User Defined Function

Hi,

I am currently using the formula below to convert an american date which is in a text format into a English date. With the formula below in mind, in my spreadsheet the American date would exist in A2 and I would convert it in B2.

=IFERROR(VALUE(TEXT(A2,"mm/dd/yyyy")),VALUE(MID(A2,FIND("/",A2,1)+1,(FIND("/",A2,FIND("/",A2,1)+1)-FIND("/",A2,1)-1))&"/"&LEFT(A2,FIND("/",A2,1)-1)&"/2013"))

This is an example of the American date TEXT format - 1/22/2013 12:00:00 AM

And it is converted to this English DATE format - 22/01/2013

What I want to do is instead of using this formula, I want to create a Public Custom Function called ConvertDate. I want to be able to type =ConvertDate(A2) in cell B2 and it return the same as the formula does.

How can I incorporate this formula into a custom function?

Any help is much appreciated!

I'd imagine you could use this:

Please Login or Register  to view this content.