| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wrong Week number
Hi,
I am in Ireland and as such Excel (2003) is putting in the wrong week numbers in my spreadsheet, for example 02/01/2006 is listed as week 0 when in fact it is week 1, how can I get it too correct this problem? I am using the following formula, could someone explain this formula in english? =CONCATENATE(YEAR(BM2),"_","w",IF((WEEKNUM(BM2)-1)<10,CONCATENATE("0",(WEEKNUM(BM2)-1)),(WEEKNUM(BM2)-1))) Regards, Noel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for a date's week number in a month (1st, 2nd, etc.) | Excel Discussion (Misc queries) | |||
| selecting by week number?????? | Excel Discussion (Misc queries) | |||
| Dates in a week number | Excel Worksheet Functions | |||
| evaluate data by week number | Excel Worksheet Functions | |||
| how to get week number in month in excel ? | Charts and Charting in Excel | |||
Threaded Mode
