2010-01-04 is equal to week 2???

[nginhong]

Dear all,

Happy New Year!

I used the following formula to display week number:-
="WEEK " & WEEKNUM(NOW(),1)

Today is 2010-01-04 (4th Jan 2010) and the formula shows WEEK 2 and check
the calendar is actually week 1. Is there anything wrong with the formula?

Also is it possible to display / convert a date to week format like 4th Jan
2010 to 10W1 or W101?

Kind regards,
Ngin Hong

 

[Héctor Miguel]

hi, !

here is why excel returns week 2 (and how to get ISO week-numbers):
http://www.cpearson.com/Excel/WeekNumbers.aspx

hth,
hector.

__ OP __