calendar in excel question?

[Nevermind]

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?

 

[David Biddulph]

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

 

[Ron@Buy]

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'

 

[Ron@Buy]

Whoops! read cell 2 as B1

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'

 

[royUK]

If the first date is in A1 then

=A1+6

 

[Shane Devenshire]

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 future:

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

or

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