Thread
:
Finding formula date
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
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
...
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann