Automatically get next Friday's date

Blank Timesheet.xlsHi
im trying to enter a date in to a time sheet for a friday so that any time the sheet is opened before a friday it will automatically insert the date for the coming friday, and when that date has passed and the sheet is re opened it will automatically insert the next fridays date in the week ending box.

Any advise would be appreciated