Calculating the Week Number

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-date-time-formulas/calculating-the-week-number.html">
SHARE




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.
Screenshot // Calculating the Week Number

 

To calculate week number in excel for year 2015; the formula is =WEEKNUM(A2,2)

 

img1

 

In this way we can easily return the current week number in excel.

Please follow and like us:
25


Leave a Reply

Your email address will not be published. Required fields are marked *


× 9 = fifty four

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>