and Weeknum of course <g

=IF(A1="","",WEEKNUM(A1,2))

--
HTH

Bob

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

"Jayjay" wrote in message
...
Also, Bob (sorry) I'm using a column of date for the week numbers, so the
fomular is: =WEEKNUM(A1,2)

But, if there is no entry yet in Column A, it returns a value of 1.

Your thoughts please...

Thank you,

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