how do i roll dates forward in excel
 

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

how do i roll dates forward in excel
 

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

On Sat, 23 Sep 2006 15:27:01 +0100, Davecl
wrote:

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



--
Steve (3)

how do i roll dates forward in excel
 

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

On Sat, 23 Sep 2006 15:27:01 +0100, Davecl
wrote:

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

how do i roll dates forward in excel
 

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

Steve
On Sat, 23 Sep 2006 15:30:48 +0100, SteveW
wrote:

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

On Sat, 23 Sep 2006 15:27:01 +0100, Davecl
wrote:

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

how do i roll dates forward in excel
 

Cheers Steve, I'll give that a go.

"SteveW" wrote:

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