Create a due date in excel

Hi there,

Here is the situation. An audit is due for an employee on the his 30th working day. I want to generate in cell E6 a due date which will equal to the date on which the employee completes his 30th day of work.

Please see the attached report and HELP! I am stuck

I am open to any other changes I could make to make it work.