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?
|