I ended up copying and pasting just the values - that changed my date in to
all numbers (# of days + 1900) and that seems to work! Strange. But, okay.
Thank you all of your help.

"Kevin B" wrote:

I've run out of ideas at this point. If possible see if this happens on a
different computer. In my experience the #REF error means that the formula
cannot be found, and in this case the week number formula is part of the
Analysis Toolpack.

Hope you can get this resolved...
--
Kevin Backmann


"JBTexas" wrote:

Kevin - I tried what you suggested by entering the Date...etc. for one cell -
that still gives me #REF.

"JBTexas" wrote:

I actually have a column with 900+ rows of dates that I wanted to the week
number for...is it possible to get to this without re-entering?


"Kevin B" wrote:

If your date has been entered as a string you could get wonky results from
the WEEKNUM formula. Try entering your date value using the DATE function to
get a true date:

DATE(Year,Month,Day)

=DATE(2007,9,5)
--
Kevin Backmann


"JBTexas" wrote:

I confirmed that I have the add-in checked - pressed F9 and still nothing...

"Kevin B" wrote:

Click TOOLS in the menu and select ADD INS. Verify that you have the
ANALYSIS TOOLPACK checked.

After turning on the add in you can press F9 to recalc the workbook and your
#REF error should be replaced by a week number.
--
Kevin Backmann


"JBTexas" wrote:

I'm trying to do that but I'm gettng #REF... and I'm not able to trace the
problem.

"Pranav Vaidya" wrote:

use weeknum() function

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"JBTexas" wrote:

I've got a column of dates that I'd like to have converted to the week # of
the year, I'm not so concerned with the date in that week as I am which weeks
are represented in the column