Formula to count no. of months between 2 dates
 

What is the formula to display the number of months between 2 dates?

Thanks,
Melissa

Formula to count no. of months between 2 dates
 

Have a look at this site:

http://www.cpearson.com/excel/datedif.aspx

--
Regards!
Stefi



€žMelissa€� ezt Ã*rta:

What is the formula to display the number of months between 2 dates?

Thanks,
Melissa

Formula to count no. of months between 2 dates
 

=DATEDIF(A1,B1,"m")

On 23 Mar, 08:27, Melissa wrote:
What is the formula to display the number of months between 2 dates?

Thanks,
Melissa

Formula to count no. of months between 2 dates
 

I forgot to mention I am using Excel 2000.
I used this formula: dateif(A3,A2,"m") and got a #NAME? result.
My dates are all in column A (in ascending order).

"Stefi" wrote:

Have a look at this site:

http://www.cpearson.com/excel/datedif.aspx

--
Regards!
Stefi



€žMelissa€� ezt Ã*rta:

What is the formula to display the number of months between 2 dates?

Thanks,
Melissa

Formula to count no. of months between 2 dates
 

There is no function DATEIF, so that is why you got the #NAME? result.
Try DATEDIF.
--
David Biddulph


"Melissa" wrote in message
...
I forgot to mention I am using Excel 2000.
I used this formula: dateif(A3,A2,"m") and got a #NAME? result.
My dates are all in column A (in ascending order).

"Stefi" wrote:

Have a look at this site:

http://www.cpearson.com/excel/datedif.aspx

--
Regards!
Stefi



"Melissa" ezt írta:

What is the formula to display the number of months between 2 dates?

Thanks,
Melissa

Formula to count no. of months between 2 dates
 

Thanks!

"David Biddulph" wrote:

There is no function DATEIF, so that is why you got the #NAME? result.
Try DATEDIF.
--
David Biddulph


"Melissa" wrote in message
...
I forgot to mention I am using Excel 2000.
I used this formula: dateif(A3,A2,"m") and got a #NAME? result.
My dates are all in column A (in ascending order).

"Stefi" wrote:

Have a look at this site:

http://www.cpearson.com/excel/datedif.aspx

--
Regards!
Stefi



"Melissa" ezt Ã*rta:

What is the formula to display the number of months between 2 dates?

Thanks,
Melissa


.