calendar in excel question?
 

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?

calendar in excel question?
 

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?

calendar in excel question?
 

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?

calendar in excel question?
 

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?

calendar in excel question?
 

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

calendar in excel question?
 

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?