Calendar Week

Calendar Week - Not all of the almanac, including those at your desk writing / show keberapa week today. Can Excel shows us Calendar Week (CW) to how many days?

The answer of course could be just one way you can find it, namely:

Write the date in the format mm / dd / yy in cell A1. example 03/15/2009
And jurusnya is: type a formula in cell A2
= weeknum (A1)
press enter, done.

The result is 12, where the number twelve indicates the 12th week in the year 2009 starting from January 1, 2009.

If the results are not as desired and up # VALUE
That's because the program to excel Add-Ins you are not active.

Here's how to activate it: select the menu Tools> Add-Ins and then click Analysis ToolPak as shown below :