# Client Tenure Formula Column

Hi Monday experts!

I’m trying to create a formula that calculates the amount of years, months and days between the start date of a client contract at our agency and TODAY. I’ve found lots of examples with an End Date, but none that just count until the present day. I basically want a column that tells me how long the client has been with the agency for.

This is what I want it to look like:

What is the formula I would use for this? Thanks so much in advance!

Cheers,
Meg

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.

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

Thanks so much Giannis that worked!

1 Like