Calulating week # & Day #

B

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
 
M

Mike H

With the date in A1

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

Should do the ttrick

Mike
 
A

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
 
Top