adjust formula to much info

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
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating time between mulitple dates 4
changed DOB to age, but if no DOB need cell to be empty. 4
Update Upon Opening based on DATEIF NOW() 10
Nested IF formula question 3
Help with formula? 1
Datedif gives wrong result 1
Summer puzzle: age as text 21
lookup? Index? match? formula 4

Top