How to determine the number of weeks at this moment?

[Eric]

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

 

[Mike H]

Hi,

Try this

=weeknum(TODAY())

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

Mike

 

[Gord Dibben]

I suggest you look up the WEEKNUM function in help.

Note............need the ATP loaded.


Gord Dibben MS Excel MVP