Diffrence between 2 dates in months

[djamy]

Hello
How can I get with Excel 2010 the diffrence between 2 dates in months. The result must be for example : 3.4 months
Thank you for your help !
Djamy

 

[Joe4]

In order to do fractional months, you will need to make some sort of assumption as to the number of days in each month, such as:
- 30 days
- 365/30 days
- 365.25/30 days

Then, as long as the dates are entered as dates in Excel, just do a formula like:

[B]=(Date2 - Date1)/30[/B]

or

[B]=(Date2 - Date1)/(365/30)[/B]

 

[djamy]

Thank you Joe
Finaly I used this one : DateDif(Date2,Date1,"m")+DateDif(Date2,Date1,"md")/30