how do I insert a function to..

[Jim]

how do I insert a function to show the current WEEK ONLY
i.e. (1 thru 52)in a cell? NOT the year, NOT the Month,
NOT the Date.

 

[Jason Morin]

Use:

=WEEKNUM(NOW(),1)

If you receive a #NAME? error, you'll need to install the
Analysis ToolPak under Tools > Add-Ins.

HTH
Jason
Atlanta, GA

 

[Peo Sjoblom]

One way

=WEEKNUM(TODAY())

needs ATP

http://www.cpearson.com/excel/weeknum.htm

 

[Peo Sjoblom]

Also if you don't have Analysis ToolPak installed you can use this formula
from Daniel Maher

=1+INT(MIN(MOD(TODAY()-DATE(YEAR(TODAY())+{-1;0;1},1,5)+WEEKDAY(DATE(YEAR(TO
DAY())+{-1;0;1},1,3)),734))/7)