| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week Number.
Is there a function where I can set a cell to give me the corresponding week
number of the year for any given date?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Week Number.
Hi GEM
There are different week number systems Start here http://www.rondebruin.nl/weeknumber.htm Or on MSDN http://msdn.microsoft.com/en-us/library/bb277364.aspx -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "GEM" wrote in message ... Is there a function where I can set a cell to give me the corresponding week number of the year for any given date?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Week Number.
Have a look in Help at WEEKNUM
If you not resident in USA, Google with something like "Excel WEEKNUM Europe" to see how to do a workaround for Europe best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "GEM" wrote in message ... Is there a function where I can set a cell to give me the corresponding week number of the year for any given date?? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Week Number.
For ISO week numbers see
http://www.cpearson.com/excel/weeknum.htm -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "GEM" wrote in message ... Is there a function where I can set a cell to give me the corresponding week number of the year for any given date?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| group sales by week and week number | Excel Discussion (Misc queries) | |||
| Week Number | Excel Worksheet Functions | |||
| Week number | Excel Discussion (Misc queries) | |||
| number of week | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
