Finding formula date
 

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

Finding formula date
 

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


with @tiscali.co.uk


"Loretta" <Loretta @discussions.microsoft.com wrote in message
...
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
...

Finding formula date
 

=EDATE(A1,60)

Required Analysis ToolPak Add-Ins


"Loretta" wrote:

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