Prev: Cells showing #####
Next: how do you calculate mortgage interest in 2007 Excel ?
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: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
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Cells showing #####
Next: how do you calculate mortgage interest in 2007 Excel ?