Auto Extend Formulas doesn't work for a particular formula

N

niwrad

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?
 
B

Barb Reinhardt

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.
 
N

niwrad

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.
 
Top