Hi is it possible to calculate the number of months and the remaining days
between 2 dates, i.e

Date 1 is 1/16/07
Date 2 is 6/10/07

So if I use the DatedIF(Date 1, Date 2,"M") i would have the # of months;
how would i have the days remaining, meaning i have 4 months, and 24 days,

help please !

Jean

Date 1 in A6................Date 2 in A7

=DATEDIF(A6,A7,"y") & "years," & DATEDIF(A6,A7,"ym") & "months,"&
DATEDIF(A6,A7,"md") & "days,"


Gord Dibben MS Excel MVP

On Thu, 29 Mar 2007 17:42:00 -0700, Jean wrote:

Hi is it possible to calculate the number of months and the remaining days
between 2 dates, i.e

Date 1 is 1/16/07
Date 2 is 6/10/07

So if I use the DatedIF(Date 1, Date 2,"M") i would have the # of months;
how would i have the days remaining, meaning i have 4 months, and 24 days,

help please !

thx a lot! that really helps!! thank you!

"Gord Dibben" wrote:

Jean

Date 1 in A6................Date 2 in A7

=DATEDIF(A6,A7,"y") & "years," & DATEDIF(A6,A7,"ym") & "months,"&
DATEDIF(A6,A7,"md") & "days,"


Gord Dibben MS Excel MVP

On Thu, 29 Mar 2007 17:42:00 -0700, Jean wrote:

Hi is it possible to calculate the number of months and the remaining days
between 2 dates, i.e

Date 1 is 1/16/07
Date 2 is 6/10/07

So if I use the DatedIF(Date 1, Date 2,"M") i would have the # of months;
how would i have the days remaining, meaning i have 4 months, and 24 days,

help please !

Note that using "md" bases days in a month on the number of days in the
month of the first argument, so you can get some weird results, like:

A6: 1/31/2007
A7: 3/01/2007

results in

0years,1months,-2days,



In article ,
Jean wrote:

thx a lot! that really helps!! thank you!

"Gord Dibben" wrote:

Jean

Date 1 in A6................Date 2 in A7

=DATEDIF(A6,A7,"y") & "years," & DATEDIF(A6,A7,"ym") & "months,"&
DATEDIF(A6,A7,"md") & "days,"