Month and Days question

[Guest]

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

 

[Ron Rosenfeld]

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

 

[Guest]

Ron

Thanks mate, that worked a treat

=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