Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
WeekNum resulting non ISO compliant result.
for examle WeekNum("01/01/2005",2) results 1. According to ISO, 1 January 2005 should be week 53 of 2004 and then first week of January 2005 start from January 3. The first week should contain the first Thursday in that year and always start from Monday. Is there any function that can return the correct week number according to ISO? Is there any reverse function of WeekNum which return the correct starting date of the given week? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Weeknum Year by Year Compare | Charts and Charting in Excel | |||
Weeknum | Excel Worksheet Functions | |||
pivot table multi line chart | Charts and Charting in Excel |