=WEEKNUM formula / function

[Steve Knight]

Using Excel 97.

Firstly not sure if this is a formula or a function! Formula, I think...?

Have received an Excel file from a colleague who uses the formula
=WEEKNUM(C12) to count the week number in the year of a date in cell C12.

If I try to drag, copy or edit this formula it errors out on me - even if I
type it manually in an empty cell; yet where he has used it works fine. It
even errors if I double click on the cell and then click elsewhere without
making a change.

Any ideas?

--
remove Xs to email direct

[Chip Pearson]

Steve,

There is a WEEKNUM function in the Analysis Tool Pack add-in for
Excel. WEEKNUM isn't one of the "standard" Excel function, but
rather is provided by the ATP (which comes with the standard
Excel package, and contains dozens of additional functions,
mostly of math and science). You must have the ATP loaded in
order to use functions in it -- if it isn't loaded, you'll get
#NAME errors.

Go to your Tools menu, Add-Ins, and find Analysis ToolPak in the
list, and put a check mark next to it. (You can leave the one
called "Analysis ToolPak VBA" unchecked -- you don't need it
now.)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"Steve Knight" <steve.x...@inamex.com> wrote in message
news:yd0D6.12802$xA.18...@news2-win.server.ntlworld.com...