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
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!