From: Melissa on 23 Mar 2010 03:27 What is the formula to display the number of months between 2 dates? Thanks, Melissa From: Stefi on 23 Mar 2010 03:43 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 From: Jarek Kujawa on 23 Mar 2010 03:50 =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 From: Melissa on 23 Mar 2010 04:00 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 From: "David Biddulph" groups [at] on 23 Mar 2010 04:08 There is no function DATEIF, so that is why you got the #NAME? result. Try DATEDIF. -- David Biddulph "Melissa" wrote in message news:29029341-C3D7-42A0-A9EA-70BA56444CFA(a)microsoft.com...> 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  |  Next  |  Last Pages: 1 2 Prev: Cells showing #####Next: how do you calculate mortgage interest in 2007 Excel ?