» 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.
Book Store:
Recommended Books:
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Microsoft Windows XP Step by Step (With CD-ROM)
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Financial Statement Analysis with S&P insert card
No comments have been submitted.
