J Jim Dec 5, 2003 #1 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.
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.
J Jason Morin Dec 5, 2003 #2 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
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
P Peo Sjoblom Dec 5, 2003 #3 One way =WEEKNUM(TODAY()) needs ATP http://www.cpearson.com/excel/weeknum.htm
P Peo Sjoblom Dec 5, 2003 #4 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)
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)
