 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2007Finding 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 ... Try =DATE(YEAR(A1),MONTH(A1)+60,DAY(A1)) Excel will take care of the year.  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk >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 > ... =EDATE(A1,60) Required Analysis ToolPak Add-Ins > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.