 |
 | 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 / Worksheet Functions / March 2006How do I find the length of time (Years & Months) between 2 dates
One way: A1: <start date> A2: <end date> A3: =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months" See http://cpearson.com/excel/datedif.htm for more documentation on DATEDIF(). =DATEDIF(date1, date2,"y") for years =DATEDIF(date1, date2, "ym") for extra months HTH -- AP I have a spreadsheet with a date inducted and a date it needs to be replaced. How do I get a cell with the remaining days between the dates and it update daily? > =DATEDIF(date1, date2,"y") for years > =DATEDIF(date1, date2, "ym") for extra months > > HTH > -- > AP =DATEDIF(date1, date2,"d") for days between date1 & date2 HTH -- AP > I have a spreadsheet with a date inducted and a date it needs to be replaced. > How do I get a cell with the remaining days between the dates and it update [quoted text clipped - 6 lines] > > -- > > AP That worked but I worded the problem wrong. I have a part inducted on 1-1-06 that has a life span of 1825 days. How can I create a formula that will give me the days remaining in a column and have that number updated daily? I'm using Excel 2003. > =DATEDIF(date1, date2,"d") for days between date1 & date2 > [quoted text clipped - 14 lines] > > > -- > > > AP =1825+DATE(2006,1,1)-TODAY() format as genera 1745 > =1825+DATE(2006,1,1)-TODAY() > > format as general It returned 1745 > 1745 > > > =1825+DATE(2006,1,1)-TODAY() > > > > format as general Is that not correct? You wanted the days remaining. If it shows 174 today it will show 1744 tomorrow and so on until it reaches zero o 31st December 2010 Well of course had I closed the application and reopened it and used my brain. Thank you so much for all the help. It seems to work like a charm. I will try it on the main sheet and see what happens. This has been very helpful. > Is that not correct? You wanted the days remaining. If it shows 1745 > today it will show 1744 tomorrow and so on until it reaches zero on > 31st December 2010. Does the 360 days a year affect the calculations? I saw where Excel uses 360 days in the year instead of 365. > Is that not correct? You wanted the days remaining. If it shows 1745 > today it will show 1744 tomorrow and so on until it reaches zero on > 31st December 2010. Using the formula I posted the calculation will be correct. There is a DAYS360 function in Excel which uses a 360 day year for accounting purposes but, other than that Excel will calculate using 365 day or 366 day years as appropriate  Signaturedaddylonglegs One way: A1: <date inducted> A2: <date to be replaced> A3: =A2-A1 format A3 as General or Number. No idea how to update it daily unless you specify how either of the dates change. > I have a spreadsheet with a date inducted and a date it needs to be replaced. > How do I get a cell with the remaining days between the dates and it update > daily? Brandon Wrote: > I have a spreadsheet with a date inducted and a date it needs to b > replaced. [quoted text clipped - 13 lines] > > message d > news:F321D1B8-0BC0-4B16-829F-156AD4BC0BFC@microsoft.com... In general to get the difference in days between two dates you onl need =B1-A1 where B1 is the later date format as general In your case it looks like you need the difference in days betwee today and your replacement date - if replacement date in in C1 =C1-today() format as genera David, Or you could use =TEXT(A2-A1,"Y, M") Beege |
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.