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:
Screen Shot 2022-12-01 at 4.14.34 pm

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


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 :

(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!

Implementation Consultant at

Thanks so much Giannis that worked!

1 Like