Why Weeknum Function Returns Wrong Value ?

Why Weeknum Function Returns Wrong Value ?

Why Weeknum Function Returns Wrong Value ?


&#13
&#13

&#13

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:

=WEEKNUM(serial_variety,[return_type])

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:

  1. 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.
  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
Day Wednesday Friday
Case in point day 25/05/2020 25/05/2021
Week variety on calendar 22 21
=WEEKNUM(Instance_Date2) 22 22
=WEEKNUM(Example_Date21) 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.

 

&#13

&#13
You may also like…

&#13



Source link