Finding formula date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to excel but what I am trying to do is put in a contract date
say today and then have excel tell me when the contract would be
dated if it were up 60 months. Can anyone help me.


Todays date of contract plus 60 months would be date that contract ends ...
 
Try

=DATE(YEAR(A1),MONTH(A1)+60,DAY(A1))

Excel will take care of the year.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top