View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj[_2_] bj[_2_] is offline
external usenet poster
 
Posts: 1
Default Calulating week # & Day #

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