Deej,
Start from A2, with the numbers 1, 2, etc downwards, until 53.
Start from B1, with the numbers 1-7 to the right. These stand for
Sunday through Saturday.
In B2 use the formula:
=DATE(YEAR(TODAY()),1,($A2-1)*7+B$1)-WEEKDAY(DATE(YEAR(TODAY()),1,1),1)+1

This will work for the current year. If you need other years, enter the
year in a separate cell, e.g K1, and substitute $K$1 for the expression
YEAR(TODAY()) wherever necessary.

HTH
Kostis Vezerides