I want to subtract 2 dates and display the result as months

[Dave]

I am trying to subtract 2 dates and return the result as number of months.

I have seen post related to DateDif but whne I use this I get a Name error.

How do I subtract dates and get number of months?

Thanks

Dave

[Nick Hodge]

Dave

=DATEDIF(A1,B1,"m")

Works for me

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

"Dave" <davekstl@charter.net> wrote in message
news:_D8Ld.28058$K07.26096@fe07.lga...
>I am trying to subtract 2 dates and return the result as number of months.
>
> I have seen post related to DateDif but whne I use this I get a Name
> error.
>
> How do I subtract dates and get number of months?
>
> Thanks
>
> Dave
>

[Ragdyer]

Start date in A1,
End date in B1,
Try this:

=DATEDIF(A1,B1,"m")

For an explanation of the function, check out Chip Pearson's web page:

http://www.cpearson.com/excel/datedif.htm

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave" <davekstl@charter.net> wrote in message
news:_D8Ld.28058$K07.26096@fe07.lga...
> I am trying to subtract 2 dates and return the result as number of months.
>
> I have seen post related to DateDif but whne I use this I get a Name
error.
>
> How do I subtract dates and get number of months?
>
> Thanks
>
> Dave
>
>

[Dave]

Thank you both - this works!


"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:OoV1eCvBFHA.2316@TK2MSFTNGP15.phx.gbl...
> Start date in A1,
> End date in B1,
> Try this:
>
> =DATEDIF(A1,B1,"m")
>
> For an explanation of the function, check out Chip Pearson's web page:
>
> http://www.cpearson.com/excel/datedif.htm
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Dave" <davekstl@charter.net> wrote in message
> news:_D8Ld.28058$K07.26096@fe07.lga...
>> I am trying to subtract 2 dates and return the result as number of
>> months.
>>
>> I have seen post related to DateDif but whne I use this I get a Name
> error.
>>
>> How do I subtract dates and get number of months?
>>
>> Thanks
>>
>> Dave
>>
>>
>