iso weeks

Hello All, I'm using a UDF to get from a yyyyww notation to a real date. I take the yyyy value from a cell, use it in ISOYEARSTART and then add 7 times the number of weeks from the same cell =IFERROR(IF(A3=0;"";ISOYEARSTART(LEFT(A3;4))+7*RIGHT(A3;2))+5;"") I add 5 days, to end up on a friday...

Hello All, it's been a while since my last post. that would mean everything is working as it should be ;) But now i face a challenge again. I need to convert a standard date to the (european) yyyyww format. I already have an ISOweek UDF Public Function WeekNumberISO(InDate As Date) As Long...

Hi all I'm using the following formula to return the current ISO week number (this week we are in week 45, for example): =1+INT((C2-DATE(YEAR(C2+4-WEEKDAY(C2,2)),1,5)+WEEKDAY(DATE(YEAR(C2+4-WEEKDAY(C2,2)),1,4),2))/7) Cell C2 is just the current date: =TODAY() So the ISO week formula returns...