Home |
Search |
Today's Posts |
#1
|
|||
|
|||
number of week
Excel gives an incorrect calendard week number.
=num.week(A1) gives 4 if in A1 is 21/01/05. Actually 21/01/05 is in week 3! Why? and more important , may I correct it? |
#2
|
|||
|
|||
Hi ciccio
You are using ISO weeknumbers, See http://www.cpearson.com/excel/weeknum.htm And http://www.rondebruin.nl/weeknumber.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ciccio" wrote in message ... Excel gives an incorrect calendard week number. =num.week(A1) gives 4 if in A1 is 21/01/05. Actually 21/01/05 is in week 3! Why? and more important , may I correct it? |
#3
|
|||
|
|||
Try this link over to Chip Pearson's site. I think this may be what you're
looking for... http://www.cpearson.com/excel/weeknum.htm HTH "ciccio" wrote in message ... Excel gives an incorrect calendard week number. =num.week(A1) gives 4 if in A1 is 21/01/05. Actually 21/01/05 is in week 3! Why? and more important , may I correct it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
calculate month from week number | Excel Worksheet Functions | |||
Dynamic Column VlookUps Based on Week Number | Excel Worksheet Functions | |||
Convert week number into calendar month? | Excel Worksheet Functions | |||
Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions |