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