Compute Tenure date to TODAY

Marilen.Navarro103391

Hello-

Can you assist me with the formula for the # of years and month?

Hiring Date is Oct 17, 2002 === What is the years and months of Tenure

Zachary Hall

I'm so sorry! Can't believe I missed that step. This should do it:

• =ROUNDDOWN((TODAY()-[Hiring Date]@row)/365)+" Years " + ROUNDDOWN((TODAY() - [Hiring Date]@row) / 30 - (ROUNDDOWN(((TODAY() - [Hiring Date]@row) / 30) / 12) * 12)) + "Months"

Zachary Hall

Hi,

Assuming you have a [Hiring Date] column you could use a formula like:

• =ROUND((TODAY()-[Hiring Date]@row)/365)+" Years " + ROUND((TODAY()-[Hiring Date]@row)/30) + "Months"

This isn't exact as there are not 30 days in every month, but it gives you a close approximation. The formula to get the exact number of months would be slightly more complicated.

Hope this helps!

Marilen.Navarro103391

@Zachary Hall

The result is 22 Years 271Months from your formula.... What I need is... for Oct 17, 2001 ---22 years 3 months Thanks.

Zachary Hall

I'm so sorry! Can't believe I missed that step. This should do it:

• =ROUNDDOWN((TODAY()-[Hiring Date]@row)/365)+" Years " + ROUNDDOWN((TODAY() - [Hiring Date]@row) / 30 - (ROUNDDOWN(((TODAY() - [Hiring Date]@row) / 30) / 12) * 12)) + "Months"