View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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
...