View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How to determine the number of weeks at this moment?

Hi,

Try this

=weeknum(TODAY())

If you get a #Name error then
Tools|Addins
Check the analysis toolpak

Mike

"Eric" wrote:

As we know, there is 52 weeks per year, I would like to determine the number
of weeks at this moment. Does anyone have any suggestions on how to determine
the number of weeks?
Thanks in advance for any suggestions
Eric