With the date in A1

=WEEKNUM(A1)
=TEXT(A1,"ddddddddd")

Should do the ttrick

Mike

"bj" wrote:

I wonder if any of you could advice me on which function(s )to use to get
the week number,
& day number of a given date.


eg) if the date is, say 11-Jan-2007.
then the day # is 4 ( Thursday)
week # is 2 ( 2nd week in the year).

Please help
Regards
Bernard