» 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:
- Windows XP for Dummies
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Marketing Plans That Work, Targeting Growth and Profitability
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Financial Modeling - 2nd Edition
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
