View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cam Cam is offline
external usenet poster
 
Posts: 165
Default WEEKNUM function not working

Sorry correction. It results "#NAME?", not ####

"Cam" wrote:

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