I have a worksheet that I am entering payroll data for employees in and in
column A of Worksheet I am entering the payroll date with a Subtotal between
each month. Our pay dates are every consecutive Friday. What is the
formula/function that I can enter that will calculate the correct date in
each row of column A without having to manually enter each Friday of a
calendar year.