entering and updating dates on a spreadsheet
 

How do I get a worksheet to automatically update dates with cells, when the
cells are not next to one another, i.e. 1-jan is in cell a3 and i would 2-jan
to appear in a7 automatically??

Help.
I can email the worksheet if you like!

Answered in your other post.

In article ,
"slewis3" wrote:

How do I get a worksheet to automatically update dates with cells, when the
cells are not next to one another, i.e. 1-jan is in cell a3 and i would 2-jan
to appear in a7 automatically??

Help.
I can email the worksheet if you like!

in cell a7 enter the formula
=a3+1

--
Don Guillett
SalesAid Software

"slewis3" wrote in message
...
How do I get a worksheet to automatically update dates with cells, when
the
cells are not next to one another, i.e. 1-jan is in cell a3 and i would
2-jan
to appear in a7 automatically??

Help.
I can email the worksheet if you like!