View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Melissa Melissa is offline
external usenet poster
 
Posts: 122
Default 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



.