My work has kept me both busy and moving for the last 6-8 weeks now. As part of that I had to travel again HK for another brief visit. I have come here yesterday and will be here till the end of this week. Hopefully I can get back to my normal life and blogging after this.
![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.