Security Officer Review Tracking Sheet.xlsx

Hello,
I have attached a spreadsheet for when my employees have a review coming due, this is to keep track of when they are due and to get them done in a timely manner.

See attached I'd like to have Column E automated to Column D, for when the employees evaluation is coming due. Also Column F should populate with a formula for one month prior to Column E. Column G should populate a formula for 2 weeks into Column F. I also want to add a formula for the count down for when the review is going to be due, for example a countdown for when Column E is arriving.

Hope this makes sense and if you need more information I can provide that for you.

Thank you,
T. Ivory