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

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 __
> 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?