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