Apr 24 2022 03:01 AM
Hi, I have a a date 21/02/2017 in cell A2
In cell B2 I enter
=WEEKNUM(A2)
I get a correct result which is 8
However, when I use return_type = 2 (for start day is MOnday) as follows
=WEEKNUM(B2;2)
I get 2 as an output.
I am really confused with this output, how come it can be 2nd week?
Apr 24 2022 03:16 AM
SolutionApr 24 2022 06:51 AM
In A2 you have number 8.
Dates in Excel actually are sequential numbers starting from 1 which is considered as Sunday, Jan 01 1900.
Thus 8 is Sun, Jan 08 1900 which is Sunday on second week of the year 1900 if weeks starts on Monday.
Apr 24 2022 08:26 AM
Apr 24 2022 03:16 AM
Solution