Date copy & increment formula
 

I have a date, 1/23/2008, in C6 of worksheet "Joe"
I would like to see 1/29/2008 in C6 of worksheet "tom" when I go there. IE
one week later date. Currently just typing it in. No biggie but is there a
better way?
Mel

Date copy & increment formula
 

=Joe!C6 + 6 entered in C6 of sheet "tom"

I would most likely add 7 if I wanted a week later.


Gord Dibben MS Excel MVP

On Thu, 28 Feb 2008 16:33:57 -0800, "shakey" <shakeyATsonic.net wrote:

I have a date, 1/23/2008, in C6 of worksheet "Joe"
I would like to see 1/29/2008 in C6 of worksheet "tom" when I go there. IE
one week later date. Currently just typing it in. No biggie but is there a
better way?
Mel

Date copy & increment formula
 

=Joe!C6+6


HTH,
JP

On Feb 28, 7:33*pm, "shakey" <shakeyATsonic.net wrote:
I have a date, 1/23/2008, in C6 of worksheet "Joe"
I would like to see 1/29/2008 in C6 of worksheet "tom" when I go there. IE
one week later date. Currently just typing it in. No biggie but is there a
better way?
Mel

Date copy & increment formula
 

So easy.
Thank you both. Gord, Weeks just seem to fly by, only six days long.
Mel
"shakey" <shakeyATsonic.net wrote in message
...
I have a date, 1/23/2008, in C6 of worksheet "Joe"
I would like to see 1/29/2008 in C6 of worksheet "tom" when I go there. IE
one week later date. Currently just typing it in. No biggie but is there a
better way?
Mel