how do I enter the date and make it carry throughout?

  • Thread starter Thread starter Julied
  • Start date Start date
J

Julied

How do I make the date I enter in one cell appear in other cells on the
spreadsheet with out needing to entr it a million times?
 
Let's assume that your date is in Sheet1, Cell A1.

You can enter the following formula into ANY cell on ANY worksheet and
whatever is in cell A1, on Sheet1 will appear there.

=Sheet1!A1

If it is a date, make sure to format the new cell as a date.

If you worksheet has a space somewhere in the name, enclose it in single
quotes like this... = 'Some Sheet'!A1

The easiest way to accomplish your task is to...
in the NEW cell type an equal sign =
then selectthe worksheet where the data is ad select the cell
then hit the enter key.
 
Same date or do you want it incremented one day per cell?

Same date. select a range, type date into active cell and hit CTRL + ENTER

Incremented date. Enter date in A1.

In A2 enter =A1 + 1

Drag/copy that as far as you want down.


Gord Dibben MS Excel MVP
 
Back
Top