how do i roll dates forward in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to create a workbook with 13 worksheets (1 for each of my 28-day
pay periods).
i have made the first sheet with the dates of my regular transactions etc,
is it possible when creating the next sheet to have the dates roll forward by
28 days automatically.
i hope i have explained myself clearly

thanks

Dave
 
I would have in the first sheet something like
A1 Date
A2 1/1/2006
A3 = A2+1
A4 = A3+1
etc, handling weekends whatever.

Then in Sheet 2 have exactly the same formula
But change A2 = sheet1!A2+28

Sheet 3 can be
 
I would have in the first sheet something like
A2 Date
A3 1/1/2006
A4 = A2+1
A5 = A3+1
etc, handling weekends whatever.
get the whole sheet set up, hours, pay etc etc

Then copy rename sheet1 as Period1

Now copy this to Period2 and Period3 etc

Then in Period2 set A3 = Period1!A3+28

Period3 can be = Period2!A3+28 or Period1!A3+56

etc
You could have the period number in the sheet somewhere,
say A1 = 1 or 2 etc
Then A3 = Period1!A3+28*(A1-1)


Steve
 
Somehow I typed in the magic keystroke to send this befor I'd finished
Ignore this one
2nd post is complete :)

Steve
 
Back
Top