Thread
:
date subtraction
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
Posts: 5,651
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
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld