WEEKNUM function returns #name in Excel 2003

[Alan K. Martinez]

I have Excel 2003 installed.

When I enter a WEEKNUM function into a cell I get #name returned. When I do
a check on the formula Excel help tells me there is an unrecognized entry.

Basically my formula looks like this

in cell C5 I have =weeknum(A5,1)
in cell A5 I have the date 12/08/2003

I'v done fourmulas for the date in A5 to break out the year, month, and day,
then re-assembled them with 'date' forumla to make sure it's a valid date
and to get a date serial number, but however I have the dates entered, the
weeknum formula doesn't work. It's as if the function is an invalid
function to begin with, but I found the formula in Excel's help files.

Has anyone else experienced this problem? And does anyone have a solution?

 

[J.E. McGimpsey]

Load the Analysis Toolpak Addin (Tools/Addins.../check the
appropriate checkbox).

 

[Alan K. Martinez]

Thank you... that solved the problem...

Load the Analysis Toolpak Addin (Tools/Addins.../check the
appropriate checkbox).

 

[Guest]

You could enter weeknum in your excel help file and then you'll find what you want.

Kevin Hu