I notice that when I put a date and drag the little square in the bottom
right of the cell to adjacent cells, the other cells will have a date
increment by one day. However, how do I do this when the cell is not
adjacent and far apart?

Another question, If I have two cell that are not adjacent and I want to add
the date (9-23-04) for the beginning of the week which is Monday and the
date for the end of the week which is sunday, How do I do this with 7 days
range but within only two 2 cells?
Thanks