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

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

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)
``````
2 Likes

Thank you! This worked.