 |
 | 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 / General Excel Questions / March 2008Running Time
Hello: I was hoping that this formula is plausible. In A1 there is a date 14/04/2010, what I am looking for in B1 is a forumla that will tell how many months are remining from today's date. A1 B1 01/04/2010 36 Thank you Dimitri You can use the DATEDIF function, as Chip Pearson describes on his web site here: http://www.cpearson.com/excel/datedif.aspx DATEDIF is only described in Excel Help for XL 2000, though it is a native function in all versions. Hope this helps. Pete > Hello: > [quoted text clipped - 8 lines] > > Dimitri =DATEDIF(TODAY(),A1,"m")  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Hello: > [quoted text clipped - 8 lines] > > Dimitri Hi Dimitri Try this =(A1-TODAY())/12 and format cell as "General" Regards Cimjet > Hello: > [quoted text clipped - 9 lines] > > Dimitri Are you sure? 12 days in a month? This gives 62 months for the example quoted, whereas it should presumably be 24 months (and not the 36 quoted by the OP). DATEDIF seems the appropriate answer. SignatureDavid Biddulph > Hi Dimitri > Try this =(A1-TODAY())/12 and format cell as "General" [quoted text clipped - 13 lines] >> >> Dimitri Sorry wrong answer Ignore my post. Cimjet > Hello: > [quoted text clipped - 9 lines] > > Dimitri |
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.