|  

» Calculating the Week Number

CATEGORY - Excel Formula VERSION - All Microsoft Excel Versions
To calculate a week number:

Use the WEEKNUM function.

The second argument in the WEEKNUM function, Return_type, determines on which day the week begins, for example, 1 for Sunday, 2 for Monday.

Note: This function is included in the Analysis ToolPak add-in. Users of Excel 97 and 2000: It is highly recommended that this Add-In be installed.

To install the Analysis ToolPak Add-In:
1. From the Tools menu, select Add-Ins.
2. Select the Analysis ToolPak checkbox, and then click OK.
Screenshot // Calculating the Week Number
Calculating the Week NumberCalculating the Week Number


Book Store:

VIEW ALL BOOKS

Recommended Books:

Print Tip
Add to My Tips
Rate This Tip
12 34 5
Rating: 2.92     Views: 50451
What is "Return Type 2"?
Russ911
In this WEEKNUM function, your example shows the results if Return Type 1 is selected.

I selected Return Type 2 and got the same numbers except for the date "2/1/2004" where I got a "5."

I.e.,
Return Type 1: 1, 6, 10, 14, 18, 23
Return Type 2: 1, 5, 10, 14, 18, 23

So what is shown with Return Type 2?
Click here to post comment
For Registered Users
Click here to Regiser
For Guest
Name
Comment Title
Comments


Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation