View Single Post
  #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?