Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If function required | Excel Discussion (Misc queries) | |||
Function required | Excel Discussion (Misc queries) | |||
If function with two results required | Excel Worksheet Functions | |||
Help required with COUNTIF/AND function | Excel Worksheet Functions | |||
Count function required | Excel Discussion (Misc queries) |