Hi

This assumes dates in A1 and A2 with A1 being the earlier date.

Datedif for those dates would normally return 1 year and 5 months using this
formula

=DATEDIF(A1,A2,"y")&" Years "&DATEDIF(A1,A2,"ym")&" Months"

To get it to round to the nearest month try

=DATEDIF(A1,A2,"y") & " years, "
&DATEDIF(A1,A2,"ym")+IF(DAY(A2)DAY(DATE(YEAR(A2), MONTH(A2)+1,1)-1)/2,1,0) &
" months"

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Microsoft" wrote:

Excel 2007

1 have a

start date: 01/01/2009
finish date: 23/06/2010

I want to calculate the length of service between the two dates to the
nearest month, eg (dates abaove) and return a string like so

result = 1 year 6 months

how can I do this?

Thanks

A


.