Calulating week # & Day #

[bj]

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

 

[Mike H]

With the date in A1

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

Should do the ttrick

Mike

 

[andy62]

If your data is in cell A1 (adjust for actual), these functions should do
what you need:

=WEEKDAY(A1,2)
=WEEKNUM(A1)

I believe the second one might be part of the AnalysisPack, which you might
be prompted to install (from the disks?)

HTH