Hi,

I have a formula written in excel for which I would like to have a udf, because it is a large formula and I would like lot of people to use it.. so instead of having a large formula being written every time, if there is udf that can be written would make the life easy.

The formula that I would like to convert in udf is:

=DATEVALUE(MID(R2,FIND("/",R2)+1,FIND("/",R2,FIND("/",R2)+1)-FIND("/",R2)-1)&"/"&LEFT(R2,FIND("/",R2)-1)&"/"&MID(R2,FIND("/",R2,FIND("/",R2)+1)+1,4))

What this formula does is it converts "26/08/2014 12:00:00 AM" in "8/26/2014" format.

So if there is a short udf which can take care of this formula would be really helpful.

Thanks in advance,

Regards,