Carim,

Your formula returns errors, as examples:

A1: 31/01/2006
B1: 01/03/2008
(British style dates dd/mm/yy)
Returns 2 395

A1: 31/06/2006
B1 01/03/2006
Returns 0 -366


I would suggest:

=DATEDIF(A1,B1,"y")&"Years "&DATEDIF(A1,B1,"yd")& " Days"

although DATEDIF() does have its own idiosyncrasies.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Carim" wrote in message
oups.com...
Hi,

If your dates are in cell A1 and B1 :
=DATEDIF(A1,B1,"Y")&" "&DATEDIF(A1,B1,"D")-365

HTH
Cheers
Carim