Creating Workbooks for Employees with Functioning Macros

Hi All,
I need to create tables for my employees and I need some help creating the formulas that I'll eventually record as macros with a shortcut so they can hit the shortcut and column e, g, and i will auto complete with their timelines.

Each analyst will be entering new lines of data for each project that they are assigned, daily. Those items must be reviewed based on an internal schedule we set. They will set the meeting date on the sheet and then I want to have formulas for several columns to auto calculate the internal deadlines they must meet in order to keep the projects on schedule.

I have attached an example document but here's what I need for one of the columns in regards to a formula.

For column E: if the meeting in column A is on a Monday, then the formula should ultimately subtract 24 days to result in a Friday some weeks prior. If the meeting in Column A is on a Wednesday, then the formula should ultimately subtract 26 days to result in a Friday some weeks prior. (reference the "Meeting Schedule" template uploaded for the correct "Big Rocks" and other days for these workbooks)

Thank you all!

In E2

=A2-(WEEKDAY($A2,2)+23)

However, for date in A2 of 14th March, this gives date of "Big Rocks Due" date of 16 Feb 2016 (Friday) whereas your Meeting schedule gives the 15th with "Review" on 16th.

Hi John,
Thank you for that. The review is technically supposed to be done by that Thursday but the team review of that work is due on the Friday so we're using that as the due date on this workbook.

How could I write the macro so that the formula for E, G, and I only enter if there is a date in A for that row?

This .

=IF(A2="","",A2-(WEEKDAY($A2,2)+23))