Recently, I needed to calculate and print start and end date of a week based on the week number. I am sharing the solution here not so much because it is particularly interesting or difficult. But mostly such that I can find it again myself if I need it :-)

I had to do this in LibreOffice Calc and the solution is tested there. I am fairly sure it works in Excel as well.

The formular assumes that the A column contains the week numbers and the formular is input in the B column.

=TEXT(DATE(2024;1;1)+(A1-1)*7-WEEKDAY(DATE(2024;1;1))+1;"mm/dd/yy") & " - " & TEXT(DATE(2024;1;1)+(A1-1)*7-WEEKDAY(DATE(2024;1;1))+7;"mm/dd/yy")

This particular formular is assuming the year is 2024. Obviously, this can be moved into a separate cell.

Sample output below.