Calculating/adding anniversaries with date functions

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
Best Answers
-
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.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Your welcome and i will be happy to help you any time, I will be grateful for your "Vote Up" or "Insightful"
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
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.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Amazing. Thank you kindly.
-
Your welcome and i will be happy to help you any time, I will be grateful for your "Vote Up" or "Insightful"
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!