Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Will the Excel WEEKNUM function become ISO 8601 compliant?
Will the Excel WEEKNUM function become ISO 8601 compliant?
This year we have to make work arounds for a lot of spreadsheets. In Outlook you can choose the number method of weeks. This Excel function should have an extra parameter to achieve this or an extension of the scope of the present parameter. |
#2
|
|||
|
|||
Hi Gilles
Maybe in the next version of Excel? You can use the function on this page in your personal.xls or Add-in http://www.rondebruin.nl/weeknumber.htm My EasyFilter Add-in can filter on it to http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gilles Moerdijk" <Gilles wrote in message ... Will the Excel WEEKNUM function become ISO 8601 compliant? This year we have to make work arounds for a lot of spreadsheets. In Outlook you can choose the number method of weeks. This Excel function should have an extra parameter to achieve this or an extension of the scope of the present parameter. |
#3
|
|||
|
|||
Ron de Bruin wrote...
Maybe in the next version of Excel? .... Want to bet on it? The easiest solution would be just to add a WEEKNUM.ISO worksheet function, but I don't believe Microsoft has added any worksheet functions since XL97 (though GETPIVOTDATA has changed since). |
#4
|
|||
|
|||
Hi Harlan
Want to bet on it? No <g -- Regards Ron de Bruin http://www.rondebruin.nl "Harlan Grove" wrote in message ups.com... Ron de Bruin wrote... Maybe in the next version of Excel? ... Want to bet on it? The easiest solution would be just to add a WEEKNUM.ISO worksheet function, but I don't believe Microsoft has added any worksheet functions since XL97 (though GETPIVOTDATA has changed since). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Function Keys in Excel | Excel Discussion (Misc queries) | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |