Displaying Year & Months

[Anonymous]

I am trying to display the tenure for an employee. I have one DATEDIFF formula that calculates the years and one DATEDIFF formula that calculates the months. In a single column, how can I have it display like "4 years, 6 Months"? Wasn't sure if the CONCATENATE function could do that for me. Thanks!

[Phil_Seamark · Accepted solution]

Hi @Anonymous

The CONCATENATE function should work, or you can just build a string like this

New column = 
  Table[Years]  & " years, " & Table[Months] & " Months"

You can be a bit smarter and include some IF statements to handle pluralisation etc. but you hopefully get the idea.