Age: Formula or vba?

[lol.xls]

I have a worksheet which calculates the amount of time an employee has been with our company. I currently use datedif, but i am unable to sort properly using this method. Is their a way to change the output using datedif from m,d,yyyy to mm,dd,yyyy? If not, anyone have a vba solution? Thanks for the help!

 

[lol.xls]

try:
=if(x3=0,(text(datedif(e3,f3,"y"),"##")&" years, "&text(datedif(e3,f3,"ym"),"##")&" months, "&text(datedif(e3,f3,"md"),"###")&" days"),(text(datedif(e3,$u$1,"y"),"##")&" years, "&text(datedif(e3,$u$1,"ym"),"##")&" months, "&text(datedif(e3,$u$1,"md"),"###")&" days"))

assumes no one works more than 99 years with your company!

Edit: Note, prefer excelestial's idea (but do we need rank() ... Just sort by number of days ? ...)

worked great. Thanks a bunch!