In A165 (and all the cells above it), i have dates and the formula listed is
for cell B165. I require column B to reflect the week number for the date
entered in column A.

The thing is that if I just copy and paste the formula in the adjacent
column B cell after entering the date in a column A cell, the formula works
and successfully evaluates the week number. it's just that the Auto Extend
feature isn't working and I have to perform a manual copy-and-paste everytime.


"Barb Reinhardt" wrote:

As I look at this, I wonder if it can't determine the weeknum because it
doesn't know what year you are working in. The week number will change for
the same date on different years.

"niwrad" wrote in message
...
I'm using Excel 2003 and in a particular worksheet, the Auto Extend
Formulas
doesn't work on a particular formula. I've turned on the Auto Extend
option
and it does work on another formula in the same worksheet. The problematic
formula is:

=WEEKNUM(DATEVALUE(TEXT(A165,"dd/mm")),2)-37+52

Can someone kindly help explain why there's a problem here?