Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2010-01-04 is equal to week 2???
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2010-01-04 is equal to week 2???
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
Sum by week number and if style is Equal to :CONC-92 or CONC-45 | Excel Discussion (Misc queries) | |||
Sum if Week Number and style is equal to any condition | Excel Discussion (Misc queries) | |||
Sum range of a week if condition is equal to.. | Excel Discussion (Misc queries) |