We are continually faced with a series of great opportunities brilliantly disguised as insoluble problems
Bookmark with:
 |
FREE initial consultation |  |
Secure Online Clients Area |
 |
Worldwide service |  |
Choice Of payments [Fixed Fee or Hourly or Daily rate] +44 (0) 208 209 0835/ 07956877605 |
» MS Excel » how to calculate the week number in ms excel
CATEGORY: Excel Formula VERSIONS: 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
how to calculate the week number in ms excel
Calculating the Week NumberCATEGORY: Excel Formula VERSIONS: 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
Practical advice for business
