Hi,

I had raised a similar post but got the answer from you.

thanks
krishna



"pinmaster" wrote:

Hi,

Try this:

=DATEDIF(start_date,end_date,"y")&IF(DATEDIF(start _date,end_dated,"y")1,"
years "," year
")&DATEDIF(start_date,end_date,"ym")&IF(DATEDIF(st art_date,end_date,"ym")1,"
months "," month")

HTH
Jean-Guy

"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)