View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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?