Hi! I have been trying to tweak some of the formulas I created and ones that the Monday support team have given. Issue is I wanted to count the tenure of an employee. example: Start Date (Date Column) : November 4, 2019 End Date (Formula Column: TODAY() Formula used so far are: This gives a…

@Sultan CONCATENATE( (ROUNDDOWN((DAYS({End Date},{Start Date})/30.4)/12,0))," years ", (ROUNDDOWN((((DAYS({End Date},{Start Date})/30.4)/12)-(ROUNDDOWN((DAYS({End Date},{Start Date})/30.4)/12,0)))*12,0))," months ", IF(DAY({Start Date}) <= DAY({End Date}), DAY({End Date}) - DAY({Start Date}) + 1, D…

Formula to count Employee Tenure in years and months

Platform discussions

Sultan (Sultan Khogeer) November 28, 2021, 6:25pm 11

Hello,

New here to monday.com

How we can add days to this formula?

What I am looking for is in the format:
2 years 5 months 19 days

Thanks…

1 Like

Topic		Replies	Views
Counting Months of Employment Formula Special workflows & use cases formula	8	2473	December 10, 2021
Seniority Formula Special workflows & use cases formula	2	2153	October 28, 2021
Formula column not calculating time period correctly Platform discussions columns , formula	5	52	October 21, 2024
Client Tenure Formula Column Special workflows & use cases formula	2	1746	December 1, 2022
Calculating months, days, years Special workflows & use cases automations , formula , calendar , reporting	6	3364	October 13, 2022

Formula to count Employee Tenure in years and months

Become part of our community groups

Can't find what you're looking for?

Can't find
what you need?

Formula to count Employee Tenure in years and months

Related topics

Become part of our community groups

Can't find what you're looking for?

Can't findwhat you need?

Can't find
what you need?