View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default weeknum function


Nelly,
Go to the Tools menu and select Add-Ins.
In the displayed list, checkmark Analysis Toolpak.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins available)


"Nelly"
wrote in message
-Hello,
I want to put together a table with dates spanning across several weeks.
I've been trying to use the weeknum function to count the dates that fall
within the same calendar week and total them together. I'm getting an error
(#NAME) when using this formula. I tried downloading the excel add-in too but
it still doesn not work.
Can someone please help?
Thanks in advance,
Nelly