software

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,quot;dd/mmquot;)),2)-37 52

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

What do you have in A165.quot;niwradquot; gt; wrote in message
...
gt; I'm using Excel 2003 and in a particular worksheet, the Auto Extend
gt; Formulas
gt; doesn't work on a particular formula. I've turned on the Auto Extend
gt; option
gt; and it does work on another formula in the same worksheet. The problematic
gt; formula is:
gt;
gt; =WEEKNUM(DATEVALUE(TEXT(A165,quot;dd/mmquot;)),2)-37 52
gt;
gt; Can someone kindly help explain why there's a problem here?
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.

quot;niwradquot; gt; wrote in message
...
gt; I'm using Excel 2003 and in a particular worksheet, the Auto Extend
gt; Formulas
gt; doesn't work on a particular formula. I've turned on the Auto Extend
gt; option
gt; and it does work on another formula in the same worksheet. The problematic
gt; formula is:
gt;
gt; =WEEKNUM(DATEVALUE(TEXT(A165,quot;dd/mmquot;)),2)-37 52
gt;
gt; Can someone kindly help explain why there's a problem here?
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.quot;Barb Reinhardtquot; wrote:

gt; As I look at this, I wonder if it can't determine the weeknum because it
gt; doesn't know what year you are working in. The week number will change for
gt; the same date on different years.
gt;
gt; quot;niwradquot; gt; wrote in message
gt; ...
gt; gt; I'm using Excel 2003 and in a particular worksheet, the Auto Extend
gt; gt; Formulas
gt; gt; doesn't work on a particular formula. I've turned on the Auto Extend
gt; gt; option
gt; gt; and it does work on another formula in the same worksheet. The problematic
gt; gt; formula is:
gt; gt;
gt; gt; =WEEKNUM(DATEVALUE(TEXT(A165,quot;dd/mmquot;)),2)-37 52
gt; gt;
gt; gt; Can someone kindly help explain why there's a problem here?
gt;
gt;
gt;