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.
Let me know if this helped!
Cheers,
Giannis
Implementation Consultant at thespelas.com
Thanks so much Giannis that worked!