On Tue, 22 Feb 2005 03:59:04 -0800, "Anthony Slater"
wrote:

Hi

This is my 'small' query
If: -


A1=22/8/2004
B1=31/12/2004

How can I display C1 as "4 months and 9 days"

TIA

=DATEDIF(A1,B1,"m")&" months and " & DATEDIF(A1,B1,"md") & " days"

See http://www.cpearson.com/excel/datedif.htm for documentation of this
built-in Excel function.


--ron