try this To return the week number of a date we can use the WEEKNUM formula. It will return a number that indicates where the week falls numerically within a year. If this function is not available, and returns the #NAME? error, install and load the *Analysis ToolPak* add-in. That is, *Tools*>*Add-ins*.
The formula syntax for the WEEKNUM formula is; *WEEKNUM(serial_num,return_type**) * *Serial_num* is any valid date. *See how Excel stores dates & times<http://www.ozgrid.com/Excel/ExcelDateandTimes.htm> **. * *Return_type* is a number that determines on which day the week begins. The default for *Return_type* is 1, or it can be omitted and the week begins on a *Sunday*. If *Return_type* is 2, the week begins on a *Monday*. *An example of WEEKNUM formula is as shown below * *=WEEKNUM(A1) * OR *=WEEKNUM(A1,2)* Where A1 houses a valid Excel date. *To hard code the date we could use;* *=WEEKNUM("3 Apr 2005")* OR *=WEEKNUM("3 Apr 2005",2* ** S Balachander On Thu, Sep 18, 2008 at 3:34 PM, Lakshmanan T S < [EMAIL PROTECTED]> wrote: > Hi friends, > > Is there any predefined function or menu in Excel by which we can reflect > the Week no inside a cell, if dates are entered in another cell? > For example, the running week now is week no 38 of the year 2008. So if we > enter in cell A1 , 09/18/2008, can we get Week no 38 in A2 by way of any > formula or function? > > Would appreciate inputs. > > Rgds, > > Lakshmanan > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
