I noticed that but I still have problems. Can I use a standard Calc functions such as date() in the basic function. It looks like I have to replace ";" with "," or I get an error. My other problem was using a type of date. The function will actually returns a number if I can get it to work.
"Anthony Chilco" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi Dennis, > User functions don't always update like the built in functions. You may > have to force a calculation after making a change to the function. > tc > > Dennis Marks wrote: > >>Thank you. I'll have to play with it. I tried a modification and I had >>problems. >> >>Function testit (theyear as integer, themonth as integer, theday as >>integer, theweek as integer) as date >> testit = date(theyear,themonth,theday) >>end function >> >>First I ran it without "theweek as integer" and a date was returned. >>I added "theweek as integer" on the function line and got errors. >>I went back and tried to change the date and it still returned the >>original date. >>I tried to use a named cell for theyear and got errors. >> >>I think I have a lot to learn. >> >>"Anthony Chilco" <[EMAIL PROTECTED]> wrote in message >>news:[EMAIL PROTECTED] >> >>>Hi Dennis, >>>Yes, you write them as basic functions in the macro editor. I've >>>attached a spreadsheet with an example. I'm cc'ing your address in case >>>the file is stripped in the list. >>>tc >>> >>>Dennis Marks wrote: >>> >>> >>>>Is there a way to create my own functions in Calc? There are some date >>>>and >>>>time functions that I would like to create. >>>> >>>> >>>> >>>> >> >> >>-------------------------------------------------------------------------------- >> >> >> >>>--------------------------------------------------------------------- >>>To unsubscribe, e-mail: [EMAIL PROTECTED] >>>For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >>--------------------------------------------------------------------- >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
