excel find start of week
=A2-MOD(A2-1,7)Excel week number to date
'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-1Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
