'ISO_8601: Week date
'the week with the starting year's first Thursday in it
' Cell D2 == Week Nr
' Cell D3 == Year Nr
'First day of week
=IF(WEEKDAY(DATE(D3,1,1),2)<=4,DATE(D3,1,1)-WEEKDAY(DATE(D3,1,1),2)-1,DATE(D3,1,1)+(7-WEEKDAY(DATE(D3,1,1),2))+1)+(D2-1)*7
'last day of the week
=IF(WEEKDAY(DATE(D3,1,1),2)<=4,DATE(D3,1,1)-WEEKDAY(DATE(D3,1,1),2)-1,DATE(D3,1,1)+(7-WEEKDAY(DATE(D3,1,1),2))+1)+D2*7-1