| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adjust formula to much info
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adjust formula to much info
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula won't adjust after sorting data | Excel Worksheet Functions | |||
| creating formula to adjust per month | Excel Discussion (Misc queries) | |||
| How do I adjust a formula a loan is displayed in a postive amount | Excel Discussion (Misc queries) | |||
| how to adjust formula dependent on current month | Excel Discussion (Misc queries) | |||
| how do u copy a formula in over 100 cells and have it adjust | Excel Worksheet Functions | |||
Linear Mode
