View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] hn.srikanth@gmail.com is offline
external usenet poster
 
Posts: 12
Default Help required on week function

Hi All,
I have dates starting from 02/02/2009 and ending on 02/27/2009 in
Coloumn A. I n coloumn B i want to know, in which week of February,
each day falls.. For Eg:- 02/02/2009 falls in Week1, 02/09/2009 in
Week2 so on... Is there any formula to get this??? WEEK NUM function
starts with January and for above example it gives the result as
Week6, which is not what I am looking for... Is some one could assist
me with???