calendar in excel question?

  • Thread starter Thread starter Nevermind
  • Start date Start date
N

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?
 
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'
 
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))
 
Back
Top