WEEKNUM function returns #name in Excel 2003

  • Thread starter Thread starter Alan K. Martinez
  • Start date Start date
A

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?
 
Load the Analysis Toolpak Addin (Tools/Addins.../check the
appropriate checkbox).
 
You could enter weeknum in your excel help file and then you'll find what you want.

Kevin Hu
 
Back
Top