Your need to change your end date to 01/01/2009, it works out the difference between dates
If you can't change your end date for some reason, you could use
=DATEDIF(A$2,B$2+1,"y")&" years, "&(DATEDIF(A$2,B$2+1,"ym")&" months, "&(DATEDIF(A$2,B$2+1,"md")&" days."))
Bookmarks