Relax, thats not a movie title or anything. I am shifting my house today, broadband will be off for a while, god knows when I will get it back. So expect some delays and wish me a smooth transit.
![Weeknumber in a month / quarter / year with excel formulas](https://chandoo.org/wp/wp-content/uploads/2024/08/SNAG-3687.png)
How to calculate WEEKNUMBER in Month / Quarter / Year with Excel?
Let’s say you have daily data and your boss wants to see the trends by week in month or week in quarter? How do you calculate the week number in a month or quarter? In this article, let me explain the logic and formulas we can use Excel for this.