Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tpapd754
 
Posts: n/a
Default HOW DO I SET UP REPEATING DATES IN EXCEL?

i am trying to set up a series of dates in cells that will show four days
consecutively and then skip the next four days and run in a continual pattern
for the entire year. for example: i want the first four cells to read
1/1/05, 1/2/05, 1/3/05, 1/4/05 and the next four to read 1/9/05, 1/10/05,
1/11/05, 1/12/05 and so on. can anyone help?
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default

See response to your other post. Please don't post the same question to
multiple groups.

On Thu, 3 Feb 2005 15:33:04 -0800, "tpapd754"
wrote:

i am trying to set up a series of dates in cells that will show four days
consecutively and then skip the next four days and run in a continual pattern
for the entire year. for example: i want the first four cells to read
1/1/05, 1/2/05, 1/3/05, 1/4/05 and the next four to read 1/9/05, 1/10/05,
1/11/05, 1/12/05 and so on. can anyone help?


  #3   Report Post  
Dave R.
 
Posts: n/a
Default

In A1 put 1/1/05
A2 put =A1+1
copy A2 down through A4.
in A5 put =A1+8
copy this down as far as you'd like.



"tpapd754" wrote in message
...
i am trying to set up a series of dates in cells that will show four days
consecutively and then skip the next four days and run in a continual

pattern
for the entire year. for example: i want the first four cells to read
1/1/05, 1/2/05, 1/3/05, 1/4/05 and the next four to read 1/9/05, 1/10/05,
1/11/05, 1/12/05 and so on. can anyone help?



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
Why does Excel Copy and Paste change dates from the original when. Excel changes dates in copy and paste Excel Discussion (Misc queries) 5 January 26th 05 06:08 PM
Entering dates in Excel 2002 DickG Excel Discussion (Misc queries) 3 January 9th 05 03:56 PM
Can I get email alerts when dates in excel are nearing? lucrecat Excel Discussion (Misc queries) 2 December 14th 04 06:14 AM
micosoft excel dates entered but changed to sequencial numbers ho. ten twenty Excel Worksheet Functions 1 December 10th 04 03:29 AM


All times are GMT +1. The time now is 11:29 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"