Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 427
Default 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)
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 427
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 427
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Mail Merging Dates from Excel - Word Simple Problem! CFD Excel Discussion (Misc queries) 1 July 13th 06 01:08 AM
add/subtract dates problem in Excel..... Gary in Pennsyl Excel Discussion (Misc queries) 3 May 31st 06 08:58 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"