adjust formula to much info

  • Thread starter Thread starter Wanna Learn
  • Start date Start date
W

Wanna Learn

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
 
Back
Top