WEEKNUM() Function

  • Thread starter Thread starter gvlral
  • Start date Start date
G

gvlral

I can't get this function to work. I followed MS' instructions in the Help
file to no avail.
A B

1 =WEEKNUM(A2,1)

2 10/28/04

The A2 cell is date formated not text.
 
Are you not getting the result as 44. What do you get instead.

- Manges
 
What does the function WEEKNUM() return? The number of the week in a year?
Is it part of some optional add-on? I only know of WEEKDAY().

Thanks and regards,
KL
 
Hi Ken,

WEEKNUM is a function included in the Analysis ToolPak addin.

From Help:

Returns a number that indicates where the week falls numerically within a
year.

If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu.

You may also find the following post by Norman Harker of interest:

http://tinyurl.com/5892z
 
Thanks for the help everyone. I loaded the Add In and everything works!
Thanks Again,
Bob
 
You must log in or register to reply here.

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

Similar Threads

Excel conditional formatting with Weeknum 4
WeekNum Trouble 4
weeknum function 3
Weeknum(today()) gives wrong weeknummer 5
WeekNum Trouble 3
Please help with a date formula. 3
Weeknum Within a Range 5
Optional argument as Variant not acting like number 4

Back
Top