ExcelBanter - Month and Days question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Month and Days question (https://www.excelbanter.com/excel-discussion-misc-queries/14342-month-days-question.html)

Anthony Slater

Month and Days question

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

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

Anthony Slater

Ron

Thanks mate, that worked a treat

"Ron Rosenfeld" wrote:

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

All times are GMT +1. The time now is 03:13 AM.