View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default date subtraction

On Tue, 9 Dec 2008 05:29:12 -0800 (PST), wrote:

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