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?

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?

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?