Solved: Calculating the Week Number Corresponding with a Specific Date

[sebas1102]

I have a range of dates at 1 coloumn. I need to determine the the week number based on the current year. is it possible?
i tried =WEEKNUM(A2,2) but got #NAME instead. How?

[mdmackillop]

Turn on the Analysis ToolPak add-in.

[sebas1102]

Thanks!

[geekgirlau]

I've marked this thread as "Solved" for you - to do this in future, go to "Thread Tools" at the top of the screen.

[sebas1102]

Ok thanks!