=weeknum() is an excel function

I have tried it three ways and only one way works

I have a range of cells that goes from First!$G$84:$AK$84 that contains the
weeknumber...the range is called week_num. If I try and use week_num in my
formula it returns (#value). If I try and use the excel function:
=weeknum(date_column) it still returns value. the only way that works is
=weeknum(g$86). I am trying to remove all the absolute references from the
formula. Don't seem to be getting it yet

And I agree with hat you said " Perhaps you're using week_num in a place
that requires a single cell reference." but why would the date_column
references be working then?

"Dave" wrote:

Hi Scottie,
$ signs in your named ranges:
You really need to have these, otherwise very weird things happen. The named
range reference becomes relative to the active cell - usually very
undesirable.

week_num=First!$G$84:$AK$84:
I can't see any reason why this should return errors. What error? Perhaps
you're using week_num in a place that requires a single cell reference.

=weeknum(date_column) produces #value error:
I run xl2000. Is weeknum a function that only exists in later versions? I
don't have it in my list. Or is it a typo for week_num?

Hope this helps.
Dave.