What is fomula for entering dates that are 7 days apart?
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
On Apr 10, 2:45*pm, G'maNancy
wrote:
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.
|