Get Week Start and End Date from Week Number
This is the easiest way to get the Week start and end date given a week number
=SEQUENCE(,2,
IF(WEEKDAY(DATE(E1,1,1))=2,DATE(E1,1,1),
DATE(E1,1,1)+7-WEEKDAY(DATE(E1,1,1)+7-2))+(D3-1)*7,6)
#excel #exceltips #exceltricks