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 <Meli...(a)discussions.microsoft.com> 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" <Melissa(a)discussions.microsoft.com> wrote in message news:29029341C3D742A0A9EA70BA56444CFA(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 ? 