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


N

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top