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]
