date subtraction

[geert.van.ransbeeck]

I have 2 dates (type dd/mm/xxxx) and I want know the exact number of
months between them.
Can anybody help?

 

[Ron Rosenfeld]

I have 2 dates (type dd/mm/xxxx) and I want know the exact number of
months between them.
Can anybody help?

=DATEDIF(Date1,Date2,"m")

Date 1 needs to be your earlier Date.

See documentation for this function at:

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

It is present in most versions of Excel, but only documented within Excel in v
2000 (I think).
--ron

 

[Jarek Kujawa]

parse this group for posts re DATEDIF function
or look it up in yr Help

 

[Pete_UK]

DATEDIF is not documented in Excel Help (except in XL2000).

Pete

 

[Pete_UK]

What does "exact" number of months mean?

You can use DATEDIF, which is described here:

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

Hope this helps.

Pee

 

[Jarek Kujawa]

........if it is available in Excel.........

;-)

 

[geert.van.ransbeeck]

Thanks for helping