Find solution
How to get difference between two dates in years, months and days?

How do you calculate the number of years , months and days between two given dates in Ms EXCEL?

  • You can find the number of days between two given days by using the function =days360(start d..., End d....). but how do you interprete those figures in to years and months and days?

  • Answer:

    Use excel Function DATEDIF say A1 is the day in question say A2 is another day in question find the number of day between the date in A1 and today =DATEDIF(A1,NOW(),"d") find the number of years between the date in A1 and today =DATEDIF(A1,NOW(),"y") find the number of month between the date in A1 and A2 =DATEDIF(A1,A2,"m")

beragama at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

a1 :start date b1 :end date c1 : = month( b1-a1)*60 + day(b1-a1) +year(b1-a1)*365 day d1 : = month( b1-a1) + day(b1-a1)/30 +year(b1-a1)*12 moth e1 := month( b1-a1)/12 + day(b1-a1)/365 +year(b1-a1)*12 year

rezazandieh

The previous function is wrong check this out: E2=start date E3=end date No of years in E4=year(e3)-year(e2) No of months in E5=(e3-e2)/30 No of days in E6=(e3-e2) in E6 all you need is format cells and select Number from list I am the XLMan

VBAXLMan

Easiest way is to simply subtract the later date from the earlier date. The resulting answer will be in the internal serial number format, not the values you need. The fix is simple. Add a custom number format for your results. Go to Format, Cells, Number, Custom (at the bottom of the list). Add a custom format for your cells. yy for years dd for days mm for months The custom number format will take care of all the behind the scenes division and formulas automatically. Be careful doing a division by 30 to derive months. For long periods of time, you may get a wrong answer since not all months have 30 days.

icepero

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.