SOLVED

WEEKNUM function using return type gives strange output

Occasional Contributor

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?

 

4 Replies
best response confirmed by Salam_ELIAS (Occasional Contributor)
Solution

@Salam_ELIAS 

I think you meant to use

 

=WEEKNUM(A2;2)

 

S1336.png

@Salam_ELIAS 

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.

Hans, you are correct, my bad, I have put B2 instead of A2, so many thanks