SOLVED

# WEEKNUM function using return type gives strange output

Occasional Contributor

# WEEKNUM function using return type gives strange output

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

# Re: WEEKNUM function using return type gives strange output

I think you meant to use

=WEEKNUM(A2;2)

# Re: WEEKNUM function using return type gives strange output

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.

# Re: WEEKNUM function using return type gives strange output

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

correct