View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cam Cam is offline
external usenet poster
 
Posts: 165
Default Weeknum function help

Hello,

I am trying to show the current week and using this formula:
=WEEKNUM(TODAY())-1, someday it works, somday it doesn't (return "#NAME?").
Why is that?

Is there other alternative? Thanks