Home |
Search |
Today's Posts |
#1
|
|||
|
|||
weeknum function says jan1=week1, mod to first 4 day week needed
using excel 2003 on xpSp2. i'm aware that MS says its normal that jan 1 is
week 1 when you're using the weeknum function. (in this year.only 1 day in week1).. how does one modify this so that week 1 of the weeknum function is the first 4 day week.. is there a mod i need to apply? |
#2
|
|||
|
|||
See Chip's site for an ISO weeknumber formula.
http://www.cpearson.com/excel/weeknum.htm -- HTH Bob Phillips "sam" wrote in message ... using excel 2003 on xpSp2. i'm aware that MS says its normal that jan 1 is week 1 when you're using the weeknum function. (in this year.only 1 day in week1).. how does one modify this so that week 1 of the weeknum function is the first 4 day week.. is there a mod i need to apply? |
#3
|
|||
|
|||
See
http://cpearson.com/excel/weeknum.htm In article , sam wrote: using excel 2003 on xpSp2. i'm aware that MS says its normal that jan 1 is week 1 when you're using the weeknum function. (in this year.only 1 day in week1).. how does one modify this so that week 1 of the weeknum function is the first 4 day week.. is there a mod i need to apply? |
#4
|
|||
|
|||
Hi Sam
See also http://www.rondebruin.nl/isodate.htm And http://www.rondebruin.nl/weeknumber.htm -- Regards Ron de Bruin http://www.rondebruin.nl "sam" wrote in message ... using excel 2003 on xpSp2. i'm aware that MS says its normal that jan 1 is week 1 when you're using the weeknum function. (in this year.only 1 day in week1).. how does one modify this so that week 1 of the weeknum function is the first 4 day week.. is there a mod i need to apply? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weeknum function returns name error | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Will the Excel WEEKNUM function become ISO 8601 compliant? | Excel Worksheet Functions |