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