MSE 2002 Alternative to Weeknum

Hello,

What can I use to replace Weeknum in 2002 which bases its result to a column of dates?

Originally Posted by Pepe Le Mokko

Do you have the Analysis Toolpack installed and activated in the add-ins submenu?
If not you should do so to install WEEKNUM

Our IT do not allow us to do so.. T_T Is there any other way we can calculate it?

Originally Posted by Pepe Le Mokko

Astonishing ! This Toolpack is standard MS issue. Maybe It's already on your machine - Check it out under the Tools menu - Add-ins (I think)

yeah, too bad we cannot activate it on our own as we are given limited access on activating such stuffs in our computer.. But the good thing is, one of our IT helped me to activate it on my excel, secretly.. hahaha! Thanks a lot though dear!

Originally Posted by daddylonglegs

If you want to exactly replicate WEEKNUM(A1) where A1 contains a date try this formula

=INT((A1-WEEKDAY(A1)-DATE(YEAR(A1),1,1))/7)+2

it works too! Thanks a lot Daddylonglegs! ^_^