Hello all,

I am new to macros and I need some help writing a macro to calculate due dates based on an existing date.

Here is what I am working with...

9WeekMacro.jpg

I started by recording this macro, but I found out from a friend that when you record a macro all of the cell references are absolute references. I want to make it so no matter how many rows of existing dates there are, or where the dates are on a worksheet, the cells next to each date will populate with the nine week date.

My thought was I could record the macro then go back and edit out the absolute references in favor of something more universal, I just don't know what that is or how to do it.

Thank you for helping me learn and troubleshoot!