Calculating/adding anniversaries with date functions

Dan Tanner

Good morning, hoping someone can help out with this.

I'm trying to create a formula using hire date and today's date to calculate the number of years working for a company. For example, if someone was hired October 12, 2019, I would like to have a "years with company" automate to "2" and send a notification to my e-mail. Is there any possible way to do this?

Thanks,

Dan

Bassam Khalil

Hi @Dan Tanner 

Hope you are fine, you can add 2 columns :

1- Date column type call it [hire date].

2- Text / Number column type call it [number of working years]

then use the following formula and convert it to column format formula to calculate how many year each employee complete:

=ROUNDDOWN((TODAY() - [hire date]@row) / 365, 0) 

The following screenshot shows a sample

Bassam Khalil

@Dan Tanner 

Your welcome and i will be happy to help you any time,  I will be grateful for your "Vote Up" or "Insightful"

Bassam Khalil

Hi @Dan Tanner 

Hope you are fine, you can add 2 columns :

1- Date column type call it [hire date].

2- Text / Number column type call it [number of working years]

then use the following formula and convert it to column format formula to calculate how many year each employee complete:

=ROUNDDOWN((TODAY() - [hire date]@row) / 365, 0) 

The following screenshot shows a sample

Dan Tanner

https://community.smartsheet.com/discussion/comment/307592#Comment_307592

Amazing. Thank you kindly.

Bassam Khalil

@Dan Tanner 

Your welcome and i will be happy to help you any time,  I will be grateful for your "Vote Up" or "Insightful"