CODEWITHSUNDEEP
exceldatetimeexcel-formuladate-arithmetic
R0bert
R0bert

Reputation: 557

Getting the week of the year of particular days, considering Monday as the first day of the week in Excel Formula

I'm trying to find the week of the year of particular dates using a formula in Excel. I found that Excel is considering the Sunday as the 1st day of the week instead of Monday as the first day.

I used the formula =WEEKNUM(A2) (where A2 is the date row) and got the result as below

--------------------------------
|  Date      |   Week of Year  |
--------------------------------
| 5/16/2015  |        20       |
| 5/17/2015  |        21       |
| 5/18/2015  |        21       |
| 5/19/2015  |        21       |
| 5/20/2015  |        21       |
| 5/21/2015  |        21       |
| 5/22/2015  |        21       |
| 5/23/2015  |        21       |
| 5/24/2015  |        22       |
| 5/25/2015  |        22       |
--------------------------------

But how do I get the result as below (Considering Monday as the first day of the week)

--------------------------------
|  Date      |   Week of Year  |
--------------------------------
| 5/16/2015  |        20       |
| 5/17/2015  |        20       |
| 5/18/2015  |        21       |
| 5/19/2015  |        21       |
| 5/20/2015  |        21       |
| 5/21/2015  |        21       |
| 5/22/2015  |        21       |
| 5/23/2015  |        21       |
| 5/24/2015  |        21       |
| 5/25/2015  |        22       |
--------------------------------

Upvotes: 0

Views: 55

Answers (1)

GMB
GMB

Reputation: 222432

Pass a second argument to WEEKNUM: 2 stands for Monday.

=WEEKNUM(A2, 2)

Upvotes: 2

Related Questions