» Calculating the Week Number
CATEGORY - Excel Formula
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Marketing Plans That Work, Targeting Growth and Profitability
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Excel Version 2002 Step by Step
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?