If in one cell I enter date 12.6.2008., I need that the cell next to
automaticly calculate date which is 60 days from that date (in this case it
would be 12.8.2008?

How to do this?

I wouldn't use a chart to do that, and that wouldn't be the right answer,
and please don't multipost.
--
David Biddulph

"Nevermind" wrote in message
...
If in one cell I enter date 12.6.2008., I need that the cell next to
automaticly calculate date which is 60 days from that date (in this case
it would be 12.8.2008?

How to do this?

If the date you enter is in cell A1 in cell 2 enter =A1+60
Make sure both cells are formated to a 'date format'

"Nevermind" wrote:

If in one cell I enter date 12.6.2008., I need that the cell next to
automaticly calculate date which is 60 days from that date (in this case it
would be 12.8.2008?

How to do this?

Whoops! read cell 2 as B1

"Ron@Buy" wrote:

If the date you enter is in cell A1 in cell 2 enter =A1+60
Make sure both cells are formated to a 'date format'

"Nevermind" wrote:

If in one cell I enter date 12.6.2008., I need that the cell next to
automaticly calculate date which is 60 days from that date (in this case it
would be 12.8.2008?

How to do this?

If the first date is in A1 then

=A1+60


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=39107

Hi,

Hate to be a party pooper but
12.6.2008+60 is not 12.8.2008 it is 8/11/08 (or in your notation 11.8.2008)

If you want the same day of the month 2 months into the futu

=EDATE(startdate,2) where startdate would be 6/12/2008

or

=DATE(YEAR(startdate),MONTH(startdate)+2,DAY(start date))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Nevermind" wrote:

If in one cell I enter date 12.6.2008., I need that the cell next to
automaticly calculate date which is 60 days from that date (in this case it
would be 12.8.2008?

How to do this?