From: Melissa on 23 Mar 2010 05:18 Thanks! "David Biddulph" wrote: > 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 > > > . >
First

Prev

Pages: 1 2 Prev: Cells showing ##### Next: how do you calculate mortgage interest in 2007 Excel ? 