What is fomula for entering dates that are 7 days apart?

  • Thread starter Thread starter G'maNancy
  • Start date Start date
G

G'maNancy

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.
 
Just add 7 on to the previous date, i.e.:

A2: =A1+7

Format the cell as you like it, then copy this down (assuming your
first date in in A1)

Hope this helps.

Pete
 
Back
Top