Hi all -

Is there a way to automatically fill in sequential days of the week (Monday, Tuesday, Wednesday, etc) and dates (1, 2, 3) in cells that are not adjacent to each other?

For example, I need to make a planner that contains one day per sheet of paper, with the full date across the top (i.e. Thursday December 6 2012). How would I set it so that the same cell on the next sheet contains the next date? (I.e. Friday December 7 2012)