=IF(DATEDIF(A1,A2,"y")=0,"",DATEDIF(A1,A2,"y")&" Y ")&DATEDIF(A1,A2,"ym")&"
M"
--
David Biddulph

"Wanna Learn" wrote in message
...
Hello how do I adjust the formula below so that when the answer is is
less
than 1 year it only shows the number of months . example 10 months to
read
read 10M not 0Y 10M and if over 1 year to show 1Y 10M
=DATEDIF(A1,A2,"y")&" Y "&DATEDIF(A1,A2,"ym")&" M"

As always, thanks