» Calculating the Week Number Corresponding with a Specific Date
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Calculating the week number corresponding with each of the dates listed in column A.
Solution:
Use the WEEKNUM function as shown in the following formula:
=WEEKNUM(A2,2)
Book Store:
Recommended Books:
- Special Edition Using Microsoft Office XP
- Learn MS Excel 2002 VBA/XML Programming
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Microsoft Office XP Introductory Concepts and Techniques
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
