Days of the Week in non-adjacent cells

[LauraInSeattle]

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)

[alansidman]

If your sheets are Sheet1, Sheet2, etc.
then on sheet2 in the cell you need the data =Sheet1!A1+1

[K m]

There is no Excel function to do this but you could set up your own function

Please Login or Register  to view this content.

Assume you what to increment the date and the date was in cell A1 of the previous sheet: The formula would be:

+PrevSheet(A1)+1

[K m]

There is no Excel function to do this but you could set up your own function

Please Login or Register  to view this content.

Assume you what to increment the date and the date was in cell A1 of the previous sheet: The formula would be:

+PrevSheet(A1)+1
=======================
Alansidman suggestion would work for one sheet but the formula could not be copied for multiple sheets