WEEKNUM function not working

C

Cam

Hello,

I have a cell to calculate current week number, =WEEKNUM(TODAY())
and I have the analysis toolpak checked in the Add-In menu, but it still
result "####". I am running Excel 2003.

What other alternative can I use to show current week? Thanks
 
M

Mike H

Hi,

The only way I know for it to return ### is if the cell is too narrow but
that seems unlikely for a (max) 2 digit number.

Is it definately #### or is it #NAME and you can't see that because the cell
is too narrow. Widen the cell and look.

Are you sure you checked the correct Toolpak, there are 2. You want the
analysis toolpak but it will do no harm to select the VB one also

Did you select the ATP after you entered the formula? If so select the cell
tap F2 and then enter.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
C

Cam

Mike,

It return "#NAME?". I did all the thing you mentioned, but still doesn't work.
Is there an alternative? Thanks
 
D

Dave Peterson

I think you should try loading the analysis toolpak once more.

In fact, excel's help for Weeknum describes (through a link) how to do this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top