dates in user defined functions

Posted by ian watkins on January 15, 2002 5:51 AM

Help. I'm trying to write a user defined function with a date as one of the arguments but if you type in 15/12/01 it treats it as a decimal - any suggestions

Ian

Posted by Juan Pablo G. on January 15, 2002 7:22 AM

What if you put it between doublequotes ? like this:

=MYUDF("15/12/01")

or simpler, put 15/12/01 in A1, and use
=MYUDF(A1)

Juan Pablo G.