Weeknum(Serialdate,2) will start the week on Monday in 2003 at least.

From Excel Help
The WEEKNUM function considers the week containing January 1 to be the first
week of the year. However, there is a European standard that defines the
first week as the one with the majority of days (four or more) falling in the
new year. This means that for years in which there are three days or less in
the first week of January, the WEEKNUM function returns week numbers that are
incorrect according to the European standard.




"Jayjay" wrote:

Actually, Bob. It's the WEEKNUB functions that I'm trying to use to give me
the numercial week of the year - it's still one or two days out when it gets
to the end of the year.

Any thoughts?

Jay

"Bob Phillips" wrote:

Default where? There is nothing that says that Sun is the first day of week
per se except the Weekday function, which can be overcome by using

=WEEKDAY(date,2)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jayjay" wrote in message
...
How do i change the (default) first day of the week from Sunday to
Monday?...

Thank you,

Jay