On Thu, 29 Sep 2005 09:15:42 +0100, Roger Govier
wrote:

Hi Ady

One way would be to use the little documented DATEDIF function

With your first date in A1 and your second date in A2
=DATEDIF(A1,A2,"md")&" days, "&DATEDFIF(A1,A2,"ym")&" months,
"&DATEDIF(A1,A2,"y")&" years"

Regards

Roger Govier



One of my peeves with the DATEDIF function is that it can give strange results
under certain circumstances. For example:

A1: 31 Jan 2005
A2 1 Mar 2007

-2 days, 1 months, 2 years


--ron