Displaying age (but not displaying zero values )

[locolindo]

Hi there,
I want to display the age of animals based on the date they were born relative to the current date. That part I think I can figure out.
However, I want to display it in a way that if the number for the year or the month is zero, it would not appear in the cell
For example, a dog that is 3 months and 5 days would display "3 months, 5 days, but NOT: 0 Years, 3 months, 5 days. When the dog got to be 1 year and 5 days, it would display: 1 year, 5 days, but not 1 year, 0 months, 5 days... Understood? In other words: any years, months or year that would be "0" would not be displayed, but the rest would...
Thanks,
Locolindo

 

[Roxxien]

Hello,

Can you give your current way to create those age?
That way, it will be easy to modify it correctly.

 

[Roderick_E]

Hi there,
I want to display the age of animals based on the date they were born relative to the current date. That part I think I can figure out.
However, I want to display it in a way that if the number for the year or the month is zero, it would not appear in the cell
For example, a dog that is 3 months and 5 days would display "3 months, 5 days, but NOT: 0 Years, 3 months, 5 days. When the dog got to be 1 year and 5 days, it would display: 1 year, 5 days, but not 1 year, 0 months, 5 days... Understood? In other words: any years, months or year that would be "0" would not be displayed, but the rest would...
Thanks,
Locolindo

Assuming C5 is where the birth date is stored, change as needed.

=IF(DATEDIF(C5,TODAY(),"y")=0,"",DATEDIF(C5,TODAY(),"y") &" years,")&IF(DATEDIF(C5,TODAY(),"ym")=0,"",DATEDIF(C5,TODAY(),"ym") &" months,") &IF(DATEDIF(C5,TODAY(),"md")=0,"",DATEDIF(C5,TODAY(),"md") &" days")

 

[locolindo]

Thanks!!!! This is exactly what I wanted

Assuming C5 is where the birth date is stored, change as needed.

=IF(DATEDIF(C5,TODAY(),"y")=0,"",DATEDIF(C5,TODAY(),"y") &" years,")&IF(DATEDIF(C5,TODAY(),"ym")=0,"",DATEDIF(C5,TODAY(),"ym") &" months,") &IF(DATEDIF(C5,TODAY(),"md")=0,"",DATEDIF(C5,TODAY(),"md") &" days")