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 !