This yr WEEKNUM Function returns completely wrong price if you are making use of it as typical. Because Excel considers the 7 days that contains 1st of January as 7 days 1 in this scenario. We can conquer this difficulty by working with return style systems.
Syntax for WEEKNUM Features is as under:
We normally use WEEKNUM Function with return type as 1 or 2 based mostly on our calendar method. But there is far more to know about return form. There is 2 programs for rerun style:
- Technique 1 considers the week containin 1st of January as to start with 7 days of the yr. If you choose to use technique 1 return forms, you need to enter retun type as 11 alternatively of 1 or 12 istead of 2.
- System 2 considers the week that contains first Thursay of the 12 months as initial 7 days of the calendar year. If you decide on to use method 2 return forms, you require to input retun variety as 21 as a substitute of 2.
Below is how it functions:
|To start with working day of he calendar year||01/01/2020||01/01/2021|
|Case in point day||25/05/2020||25/05/2021|
|Week variety on calendar||22||21|
You can modify your WEEKNUM formula based on over instruction to get suitable results. All you require to do is to be conscious of which working day is the first working day of the year.
You may also like…