ExcelBanter - Difference betn 2 Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Difference betn 2 Dates (https://www.excelbanter.com/excel-discussion-misc-queries/50360-difference-betn-2-dates.html)

John

Difference betn 2 Dates

Can anyone tell me a formula to get the difference between 2 dates in Months
for the following example

Ex:
10/14/2005 ; 8/23/2010

Is there a formula to get the difference bet'n the above two in Months?

John

Thanks Gary...It works

"Gary''s Student" wrote:

Use DATEDIF() If your dates are in A1 and B1, then=DATEDIF(A1,B1,"M")
gives 58 months
--
Gary''s Student

"John" wrote:

Can anyone tell me a formula to get the difference between 2 dates in Months
for the following example

Ex:
10/14/2005 ; 8/23/2010

Is there a formula to get the difference bet'n the above two in Months?

Gary''s Student

Use DATEDIF() If your dates are in A1 and B1, then=DATEDIF(A1,B1,"M")
gives 58 months
--
Gary''s Student

"John" wrote:

Can anyone tell me a formula to get the difference between 2 dates in Months
for the following example

Ex:
10/14/2005 ; 8/23/2010

Is there a formula to get the difference bet'n the above two in Months?

All times are GMT +1. The time now is 04:00 AM.