When I apply this function for 2005, it seem the weeknum is not correct. For
example, 6/1/2005, the weeknum will return WK2, however, which should be WK1.
Would u have any idea???

It's microsofts interpretation of week. For them the first week of 2005 is 5
days long, preceeded by 2-day long last week of 2004 (as you didn't
determine otherwise through optional parameter, the week returned by WEEKNUM
starts with Monday).

When you need an ISO weeknumber, you have to use some formula for it - which
one depends on country you live in (on ISO estabilished the there are a
couple of them used worldwide, they differ how is determined the first week
of year, and what is starting day for week), or you want tou use.

--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"Christine" wrote in message
...
When I apply this function for 2005, it seem the weeknum is not correct.
For
example, 6/1/2005, the weeknum will return WK2, however, which should be
WK1.
Would u have any idea???

A correction!

(as you didn't determine otherwise through optional parameter, the week
returned by WEEKNUM starts with Sunday).



--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)

Christine,

A complex matter. Take a look at http://www.cpearson.com/excel/weeknum.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Christine" wrote in message
...
When I apply this function for 2005, it seem the weeknum is not correct.
For
example, 6/1/2005, the weeknum will return WK2, however, which should be
WK1.
Would u have any idea???