Client Tenure Formula Column

Hi Meg, welcome to the community!

I believe I have found what you are looking for.

Firstly you will need a date column with the item creation date ( I named it Start Date) and a formula column ( I named it Today) with the current date ( Today() ). Then a formula column with the following formula :

CONCATENATE(
(ROUNDDOWN((DAYS({Today},{Start Date})/30.4)/12,0))," years ",
(ROUNDDOWN((((DAYS({Today},{Start Date})/30.4)/12)-(ROUNDDOWN((DAYS({Today},{Start Date})/30.4)/12,0)))*12,0))," months ",
IF(DAY({Start Date}) <= DAY({Today}), DAY({Today}) - DAY({Start Date}) + 1, DAY({Today}) + DAY(EOMONTH({Start Date}, 0)) - DAY({Start Date}) + 1), " days")

It should work like this.

image

The answer was based on a previous topic here, so credits mostly to everybody who answered there.

Similar Topic

Let me know if this helped!

Cheers,
Giannis
Implementation Consultant at thespelas.com