Translate formula values to dates

I'm stumped! In the attached spreadsheet, there is a formula in column H that results in a value that is a number, or the text "Past Due", or the text "Deferred".

This is a projection report. The number values in column H represent the week that the funds are expected. The report is run weekly and should report everything "Past Due" + week "1" for week 1. Week 2 is week 2. Week 3 is week 3, etc.

How can I get the values in column H to correspond with an actual period ending date? For example, if week 1 ends on Nov. 4th I would like the cell to display W/E Nov. 4...week 2 would display W/E Nov. 11 and so on.

Is there any way to achieve this?

Thank you in advance.

Janet