Calculte number of months from today, while keeping the number format

Platform discussions Special workflows & use cases
1

Hi,

We need to calculate time of months that have passed since today, but the column date must remain in number format so we can use the mean function to know the medium amount of months easily.

We currenty have this formula, but it doesn’t keep the number format on the column, making it difficult to calculte the medium amount of months a person is on the company:
CONCATENATE((ROUNDDOWN((DAYS(TODAY(),{StartDate})/30.4)/12,0))," anos “,(ROUNDDOWN((((DAYS(TODAY(),{StartDate})/30.4)/12)-(ROUNDDOWN((DAYS(TODAY(),{StartDate})/30.4)/12,0)))*12,0)), " months”)

Can someone help us out?

BIG THANKS!

Andreia

2

Hi @AndreiaBraga,

If you want a number, then you can’t have the field display “6 years 3 months”, you can only have a number of years or months (or days, I guess).

Years:

YEARFRAC({StartDate},TODAY())

Months:

YEARFRAC({StartDate},TODAY())*12

Months (completed):

ROUNDDOWN(YEARFRAC({StartDate},TODAY())*12,0)

Source: The monday Hidden Functions – The Monday Man

2 Likes
3

Thank you! This worked.